Another If/Then Statement Please

[Carol Fraser]

Here are my arguments:

If E3=85,.5
If E3=90,.75
If E3=95,.9
If E3>1,E3
If E3<.85,0

Help please.

 

[Jon von der Heyden]

Perhaps:

=IF(ISNA(VLOOKUP(E3,{85,0.5;90,0.75;95,0.9},2,0)),IF(E3>1,E3,0),VLOOKUP(E3,{85,0.5;90,0.75;95,0.9},2,0))

...but what do you want to do if E3 is greater than 0.85 and less than 0?



EDIT: Hello Andrew... Long time

 

[Andrew Fergus]

Hi Carol

Assuming you have made some typos with your example, for instance 85 should be .85 or 85%, what result would you want to see for 0.86?

Andrew

 

[Carol Fraser]

I'm a dork. Yes, there needs to be something in between. So, .5 for 85 to 90, .75 for 90 to 95, etc.

Sorry about that....very tired.

Thanks.

carol

 

[Andrew Fergus]

Hi

Using Jon's approach, try this formula:
=IF(E3>=1,E3,VLOOKUP(E3,{0,0;0.85,0.5;0.9,0.75;0.95,0.9},2))

Andrew

P.S. Hi Jon, yes it has! I've been flat out lately......

 

[Carol Fraser]

Andrew, sorry but as I said earlier, I'm a dork. How would I write it if:

E3 is between .85 and .90, .5
E3 is between .90 and .95, .75
E3 is between .95 and 1.0, .9
E3 > 1, E3
E3 < .85, 0

 

[schielrn]

His solution should meet your needs? Have you tried it, are you not getting the results you expect?

 

[Andrew Fergus]

Hi Carol

As suggested by schielrn in what way is this not working? Are the values at each cusp causing problems - e.g. should 0.9 be 0.50 or 0.75?

And don't be too hard on yourself.....

Andrew