Help please

[melissay]

=IF(OR($E$10>"1.0",$E$10<"1.0"),0.5,$E$10*0.25)

I have this formula but it works for the greater than 1.0 but if i choose 0.75 in the E10 cell the formula doesn't change to multiply by 0.25

Any help please

 

[Fluff]

At the moment the only time E10 will be multiplied by 0.25 is if it equals 1.0
try
=IF($E$10>"1.0",0.5,$E$10*0.25)

 

[melissay]

Brilliant thanks that works, i also need to join the following 3 formulas together could you help

=IF($A$10="E",0,$C$10)
=IF($A$10="E",0,$C$10+($B$10*10%))
=IF($A$10="E",0,$C$10+($B$10*20%))

 

[Fluff]

You'll need to give further info.
What are the conditions for each formula? ie when should the cell =C10, when should it = C10+.1*B10 etc

 

[melissay]

$0 - $40m = Std
$40- $80m = Std + 10% of AMF
$80m + = Std + 20% of AMF

 

[melissay]

Q,R and S are the cells that host the 0-40,40 - 80 etc

 

[Fluff]

Is this what you need?
=IF(A2<=40,C2,IF(A2<=80,C2+(B2*0.1),C2+(B2*0.2)))

 

[melissay]

great thanks that works! Appreciate it!!!

 

[Fluff]

You're welcome