How do you write a "nested IF formula" in Excel?
- by Mike
I manually enter numbers on one cell according to text values in the cell adjacent to it. Is there a way to use the IF function to help me manage this? The text is automatically generated with a report but I put the numbers in manually in Excel.
Example of my weekly boredom below:
number Text in Cell
3 Order A
3 Order A
1 …