Need help with a formula.

[Steve Cohen]

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

 

[J.E. McGimpsey]

Unfortunately, you can't access the conditional formattings Truth
value directly. You can use the same formulae however. If I'm
parsing your statements correctly:

IF AWA>=AWB*5 Then AWT
IF AWA<AWB*5 Then If ((AWT-AWB) > AWT) Then (AWT-AWB) Else 0

The second line can be simplified to

IF AWA<AWB*5 Then If AWB<0 Then (AWT-AWB) Else 0

Combining and putting into an IF() statment:

=IF(AWA>=AWB*5, AWT, IF(AWB<0,(AWT-AWB),0))