Need help with a formula.

Giganews Newsgroups
Subject: Need help with a formula.
Posted by:  Steve Cohen (sacoh…@bellsouth.net)
Date: Sun, 5 Oct 2003

I'm looking for a formula that will do the following...

If the conditional formating in C2(=All_World_Activity>=All_World_Bonus*5)
is true it will display the contents of F4(which can also be a cell named
All_World_Total).

If the conditional formating in C2(=All_World_Activity>=All_World_Bonus*5)
is false it will see if F4 (or All_World_Total) - Trans_type!F6 (or
All_World_Bonus) is greater than F4 (or All_World_Total).

If it is it will display =F4-Trans_type!F6 (or
=All_World_Total-All_World_Bonus).

If the above F4 (or All_World_Total) - Trans_type!F6 (or All_World_Bonus) is
<= or equal to F4 (or All_World_Total) is will display 0.

I have a couple of thing that don't seem to work quite right and I can't
combine them.
=IF((All_World_Total-All_World_Bonus<=All_World_Total),"0",(All_World_Total)
)
=IF(C2=TRUE,(All_World_Total),(All_World_Total-All_World_Bonus)).

Thanks;

Steve

Replies