M
M
Meyvorrrata2015-04-17 22:58:07
excel
Meyvorrrata, 2015-04-17 22:58:07

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

2 answer(s)
O
Oleg Matrozov, 2015-04-18
@Meyvorrrata

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.

M
Meyvorrrata, 2015-04-17
@Meyvorrrata

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 question

Ask a Question

731 491 924 answers to any question