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

A

A

Aison2019-02-15 14:43:10

excel

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

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

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

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

S

Sergey2011-06-01 19:29:56

help with excel formula 1Reply

S

SP-20212021-06-20 10:53:24

How to link row to cell value in excle/google google spreadsheet? 1Reply

A

Andrew2011-06-11 16:22:56

Formula question in Excel 3Reply

O

Otrivin2018-02-20 11:15:50

How to extract data from eml or mbox emails? 2Reply

S

Syntex2018-02-28 01:17:05

What is the best way to convert excel to xml with a schema? 0Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question