Help writing a IF formula
Solved/Closed
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
- Clear only the formatting from the selected cell (leaving the content) - Guide
- Photoshop multiple selections - 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!
