Calculation

D

Daywalker

Help,

I am trying to get a calculation to do the following.........

=If >800

Then * by 0.40

=If <800 then insert '0'

ie : if the cell contains a value of 914, it should display the value
of 45.60, and if the cell contains a value less than 800, it should
then display 0.

So I have been trying to do this.............

=if(A1>800,*0.40, if(A1<800,0))

But it does not work ?, can anyone help with this one ?
 
D

daddylonglegs

I don't see how you get 45.6 from 914*0.4 but from what you ask...

=A1*(A1>800)*0.
 
S

SteveG

=IF(A1>800,A1*.4,if(A1<800,0))

This assumes that you want to multiply A1 by .4 if the condition is
true. If not then the cell should be zero. Only problem is if it is =
to 800, it will return FALSE. If you want it to be something different
if it is = 800 then change the formula to.

=IF(A1>800,A1*0.4,IF(A1<800,0,your third value here))

HTH

Steve
 
D

Daywalker

Apologies,

I want the cell to look, and if the value is greater than the 800 (ie
914). then the calculation would then be 114 * 0.40 = 45.6
 
S

SteveG

Ok so the difference between that value 914 and 800?

=IF(A1>800,(A1-800)*.4,if(A1<800,0))


or


=IF(A1>800,(A1-800)*0.4,IF(A1<800,0,your third value here))

or if it does not matter if the cell is = to or less than 800 to appl
your zero then.

=IF(A1>800,(A1-800)*.4,0)

HTH

Stev
 
Top