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
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