Nested If ?

[Darrian]

Hi
This is probably simple to achive but I am having some difficulties in
achieving
the required results. The argument I wish to achieve is to look at the
fig in one column and multiply by 1,2or3 acording to its value i.e

smaller or equal to 14 then * 1
smaller than 30 but larger than 14 then * 2
smaller than 50 but larger than 30 then * 3
etc

Any help would be appreciated

Regards
Darrian

 

[Paul Corrado]

Darrian,

=(A1<=14)*1+(A1>14)*(A1<=30)*2++(A1>30)*(A1<=50)*3.......

PC

 

[Ron Rosenfeld]

Hi
This is probably simple to achive but I am having some difficulties in
achieving
the required results. The argument I wish to achieve is to look at the
fig in one column and multiply by 1,2or3 acording to its value i.e

smaller or equal to 14 then * 1
smaller than 30 but larger than 14 then * 2
smaller than 50 but larger than 30 then * 3
etc

Any help would be appreciated

Regards
Darrian

=A1+A1*(A1>14)+A1*(A1>30)+A1*(A1>50)+A1*....


--ron

 

[Adrian]

Try this:
=IF(A1<=14,A1*1,IF(AND(A1>14,A1<30),A1*2,IF(AND(A1>30,A1<50),A1*3,"Try again
dude!")))

HTH.