If, then trouble

[peterdanton]

Trying to create if/then formula which will look at a cell and make th
following calculation

=if(A8>1.5=100, .71<A8<1.49=75, .41<A8<.7=50, A8<.4=25)

A8 is a result of another formula, so could I be drawing on more than
functions?



Thx,

Pete

 

[Trevor Shuttleworth]

Peter

=IF(A8>1.5,100,IF(AND(0.71<A8,A8<1.49),75,IF(AND(0.41<A8,A8<0.7),50,IF(A8<0.
4,25))))

Regards

Trevor

 

[peterdanton]

Trevor,

Cut and pasted your solution and still received an error message.

Thoughts?

Thanks for the help,

Pete

 

[AlfD]

Hi!

I like to turn these things round a bit so that a sort of siev
operates:

=if(A8<0.4,25,if(A8<0.7,50,if(A8<1.49, 75,100)))

Read it in plain language: if A8 is less than 0.4, put 25; otherwise
if A8 is less than 0.7, put 50; otherwise, if A8 is less than 1.49,
put 75; otherwise put 100.

I take it you are happy with what happens at some of the interstices
The gap between 1.49 and 1.5 is covered in my formula but not in you
description, for example. It may be values between 1.49 and 1.50 can'
happen, of course. There are other similar discontinuities.

Al

 

[peterdanton]

Alf,

Your solution was right on! This site is wonderful, a true resource.


Cheers,

Pete