Help writing a IF formula

Solved/Closed
Report
-
 Blocked Profile -
Hello,

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:

=IF(LOGIC_TEST,TRUE, FALSE)


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!
9
Thank you

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

CCM 2821 users have said thank you to us this month