0

I am trying to assign multiple conditions to a cell in excel using the IF formula.

What I want to achieve is that if the value of cell A is greater than 12000, but less than 75000, then the operation to be performed is to multiply the value of cell A by 0.1. In turn, I want that if the value of A is less than or equal to 1000 then the value of the cell with the formula will always be 100.

Destroy666
  • 5,299
  • 7
  • 16
  • 35
Edgar Dominguez
  • 1
  • 2
    Generally you can use `IFS` however you don't specifcally say what happens to numbers between 1000 and 12000, nor if the number is greater than 75000 – gns100 May 24 '23 at 21:17
  • Sorry, I forgot to mention. If number is greater than 75000, the value of the cell becomes "3000" and if the number is greater than 1000 but less than 12000, the original value of cell "A" is to be multiplied by 0.1 – Edgar Dominguez May 24 '23 at 22:27
  • 1
    Instead of answering in the comments [edit your question](https://superuser.com/posts/1785781/edit) and clarify what you expect for each numbers range. But based on your last comment it seems that both 12000-75000 and also 1000-12000 should have the same output of A*0.1. Is that correct (if so why does the question say "greater than 12000")? – Yisroel Tech May 24 '23 at 22:41
  • Could you please share us with a simple sample? It seems that your request is not clear enough. Thx~ – Emily May 25 '23 at 01:46

1 Answers1

1

This is called a nested IF function. What you want to do is to at each step specify what to do if_true, and then if_false put another IF with the next condition.

Something like:

=IF(A1>75000,3000,IF(A1>12000,A1*0.1,IF(A1>1000,A1*0.1,100)))
Yisroel Tech
  • 9,687
  • 3
  • 23
  • 37