IF Formula using multiple '&' parameters

  • Thread starter Thread starter hillryane
  • Start date Start date
H

hillryane

Trouble with seemingly simple formula

Original written formula (C4 and E4 are separate formula results)
In this example C4=1.02 E4=.61

C4>.66 and E4<.66 = Disc (Correct answer)
C4<.66 and E4<.66 = Blade
C4>.66 and E4>.66 = Sphere
C4<.66 and E4>.66 = Rod

Excel formula as I have it written.

=IF(C4>0.66&E4<0.66,"Disc",IF(C4<0.66&E4<0.66,"Blade",IF(C4>0.66&E4>0.66,"Sphere",IF(C4<0.66&E4>0.66,"Rod","Other"))))

Returns Sphere. Why? What have I done wrong.
 
=IF(AND(C4>0.66,E4<0.66),"Disc",IF(AND(C4<0.66,E4<0.66),"Blade",IF(AND(C4>0.
66,E4>0.66),"Sphere",IF(AND(C4<0.66,E4>0.66),"Rod","Other"))))


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
You can't use "&" as a fuction,
i think the following will work just fine

=IF((AND(C41>0.66,E41<0.66)),"DISC",IF(AND(C41<0.66,E41<0.66),"BLADE",IF(AND(C41>0.66,E41>0.66),"SPHERE",IF(AND(C41<0.66,E41>0.66),"ROD","ERROR"))))

good luck, anmd let me know if its OK
(e-mail address removed)
 
Back
Top