Nested If ?

  • Thread starter Thread starter Darrian
  • Start date Start date
D

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
 
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
Click to expand...


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


--ron
 
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.
 
Back
Top