G
Guest
I thought this would be easy but I am drawing a blank. I just need a formula
in a cell that does the following: Assuming I want the value to come up in
cell I need to tell that cell
IF A1=2, value if true 100-25, value if false 100; IF A1=3, VIT 100-50, VIF
100; IF A1=4, VIT 0, VIF 100.
I can do one IF analysis but can't seem to get all three in one formula.
Thank you!
in a cell that does the following: Assuming I want the value to come up in
cell I need to tell that cell
IF A1=2, value if true 100-25, value if false 100; IF A1=3, VIT 100-50, VIF
100; IF A1=4, VIT 0, VIF 100.
I can do one IF analysis but can't seem to get all three in one formula.
Thank you!