Perform functions based on conditions met

0

0-0 Wai Wai ^-^

Hi.
I would like to do the following:
- if condition A is met, it will perform forumla A; If B, formula B; and so on.
Eg: If a series of data has 5 numbers, it will check if the value is larger than
8. If 6, larger than 6.
 
0

0-0 Wai Wai ^-^

Do you mean

=IF(A1="cond1",formula_A,If(A1="cond2",formula_B,...)) etc.
Click to expand...

Yes, correct.
So how to do?

Additional information:
- I'm using Office XP
- I'm using Windows XP
 
B

Bob Phillips

That was how to do it.

--
HTH

Bob Phillips

0-0 Wai Wai ^-^ said:
Yes, correct.
So how to do?

Additional information:
- I'm using Office XP
- I'm using Windows XP
Click to expand...
 
Top