Simple division and multiplication formula

[bucci35]

I can't get this formula to work, any ideas?

=IF(E1-(A1*-E1)<C1,C1,0)

a1 is a percentage that the user enters
c1=$48.00
e1=$50.00

 

[Barrie Davidson]

What do you want the formula to do??

 

[bucci35]

oops left stuff out

=IF(E1-(A1*-E1)<C1,C1,0)

if e1 times 20% is greater than c1 then c1 otherwise 0

a1 is where user enters a percentage

 

[bucci35]

=IF(E1-(A1*-E1)<c1,c1,0)

heres the one I have

 

[bucci35]

wow, my reply keeps leaving part of the formula out? wonder why

 

[Barrie Davidson]

Is this what you need?

=IF(E1*A1>C1,C1,0)

 

[bucci35]

=IF(E1-(A1*-E1)<C1,C1,0

Here it is

 

[Barrie Davidson]

wow, my reply keeps leaving part of the formula out? wonder why

Try putting your formula in as code. Select your formula and then click on the "Code" button.

 

[bucci35]

oops same problem

the ending is

,c1,c1,0)

 

[Barrie Davidson]

So your formula is:

=IF(E1-(A1*-E1),c1,c1,0)