Additional evaluation in an IF statement

Frank Freese
Frank Freese used Ask the Experts™
on
Folks,
The IF statement in cell C35 below needs to also evaluate cell A35 further. If A35 = blank or zero then C35 =" " else it is correct or wrong.
=IF(A35=1600,"Correct","Wrong")

Open in new window

Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Lead Software Engineer
Commented:
Use a Nested IF:
IF(OR(A35="", A35=0), " ", IF(A35=1600,"Correct","Wrong"))

Author

Commented:
Thank -  I was trying to incorporate an OR

Author

Commented:
Thank you very much

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial