Help writing a IF formula
Solved/Closed
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.
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.
Related:
- Write a formula in cell f32 that outputs a date formatted as mm/dd/yyyy using the dropdown selections.
- Date formula in excel dd/mm/yyyy - Guide
- How to write & in laptop - Guide
- Number to words in excel formula - Guide
- How to make multiple selections in photoshop - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
1 response
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:
NOW format the cell to change under CONDITIONAL FORMATTING!
Have FUN!
I have said it once, I will say it again. IT!
=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!
