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

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

PC
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Complex formula assistance please. 4
Problem with IF function 3
Nested formula...I think 1
Deducting breaks from time measurements 1
And function into If function 4
formulas 2
Nested If's 2
Help with Nested IF Statements 4

Back
Top