More Formulas...

[Anx]

Hi, I need a single formula to do this please ......

If A1<6 then C1=D1,

If A1>=6 but<9 then C1=D1+30%

If A1>=9 then C1=D1+60%

Hope that makes sense, it was the easiest way i could think of explaining what i need


..oh yeah, no macros allowed


Thanks for your help as always.

Anx
This message was edited by Anx on 2002-04-15 17:09

 

[Albert 1]

In C1 comes:
=IF(A1<6,D1,IF(A1>=9,D1*1.6,D1*1.3))
This message was edited by Albert 1 on 2002-04-15 17:31

 

[Ricky Morris]

I'm assuming that the formula will be in cell C1. Here you go:

=if(A1<6,D1,if(A1<9,D1*1.3),D1*1.6)

 

[Jay Petrulis]

How about:

=IF(A1>=9,1.6,IF(A1>=6,1.3,1))*D1

a little less typing.

Jay

 

[Anx]

Thanks all