Help writing a IF formula

 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 2821 users have said thank you to us this month