How to solve a problem with an "if" condition in excel?

A

Aison2019-02-15 14:43:10

excel

Aison, 2019-02-15 14:43:10

hello, guys,
please help me solve the problem with the "if" condition. the yellow cell with the result must be empty or n/ a .

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

B

Bcoon, 2019-02-15
@Aison

Swap the conditions.
=IF(OR(B3="";C3="");"n/a";IF(B3>=C3;"-";"+"))

Similar questions

B

Breaking-cat2014-08-17 00:43:57

B

BMaks_N12019-02-05 21:23:13

Z

ZeroMan2020-11-10 09:04:12

A

AlexDzen2016-09-10 20:26:48

K

Kirill Sirenko2016-09-13 18:33:40

Didn't find what you were looking for?