If FOrmula help

A

alexm999

Ok Now it works... But here's an add on question

I need help with an IF statement or some thing similar.

If the # is lower than $200 do one formula and if the number is greate
than $200 do another formula.

How can I add this to a cell?
Here are my 2 formulas:

=(J2-25)/1.2*128.7%+J2+(25)

=(J12-15)/1.05*128.7%+J12+15

The above formula is for amounts greater than $20
 
B

Bob Phillips

=IF(A1<200,(J2-25)/1.2*128.7%+J2+(25) ,(J12-15)/1.05*128.7%+J12+15)


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top