Answer the question
In order to leave comments, you need to log in
MS Excel how to implement similar expression?
The price is entered in one field, and the text output to the next cell depends on the price, if x (price) > 14000 then x * 1.075, if 10000
Answer the question
In order to leave comments, you need to log in
Maybe I don’t quite understand ... but what prevents you from using a nested IF?
Where is your price in cell A1.
It seems that nothing more is needed.
In the second case x is greater than 10000 and less than 14000, in the third case x is less than 5000 how to write a formula in 1 cell using only if and data check commands?
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question