S
SmartBlond
I am trying to use a different formula based on the value of cell.
So if the the cell value is "Store" use A1+B1+C1
If the cell value is "HQ" use A1+C1+F1
I know I can make a nice long IF formula (I actually need 3 different ones),
but can I put a formulas in other cells and refer to a different one in based
on the cell values?
Or any other creative idea is welcomed.
So if the the cell value is "Store" use A1+B1+C1
If the cell value is "HQ" use A1+C1+F1
I know I can make a nice long IF formula (I actually need 3 different ones),
but can I put a formulas in other cells and refer to a different one in based
on the cell values?
Or any other creative idea is welcomed.