Hi,
Is there a way to use ' IF ' function to make a formula with three (or more) possible outcomes ? e.g. -
IF cell A1 = E B1 = $19 or
IF cell A1 = F B1 = $22 or
IF cell A1 = G B1 = $25
Or is there another function in excel where I can achieve something like the above ?
Thanks,
Wendy
Is there a way to use ' IF ' function to make a formula with three (or more) possible outcomes ? e.g. -
IF cell A1 = E B1 = $19 or
IF cell A1 = F B1 = $22 or
IF cell A1 = G B1 = $25
Or is there another function in excel where I can achieve something like the above ?
Thanks,
Wendy