Help writing a IF formula [Solved/Closed]

 Blocked Profile -

I need to write an IF formula for excel. Cell A2 will either say ''receive'' or ''deliver''.

This formula works IF(A2=''receive'',1,2); but it doesnt do everything i need.

If cell A2 is a "receive" then it should produce a "1", if it is a "deliver", it should produce a "2", if call A2 is anything else (other than ''receive'' or ''deliver'') it should produce an error message or turn the cell red possibly. Any help with this would be greatly appreciated.

1 reply

Ok the Syntax for the IF() formula is as follows:


Apply that syntax to A2 in your sheet as in: =IF("testing 1",1,2)

If statements can BE NESTED. So you could test for a false as so:

=If("testing 1",1,IF("Testing 2",2,0))

NOW format the cell to change under CONDITIONAL FORMATTING!

Have FUN!

I have said it once, I will say it again. IT!
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!