Help

[jmaw3]

I need a formula for this:

=IF(AND(MU2265>=-1,MU2265>=1),$B$3/MO2265,IF(MU2265>1,$B$4/MO2265,IF(MU2256<-1,$B$4/MO2265,)))

if mu2265 is between -1 and 1 then do (X) but if it is more than 1 do (Y) and if it is less than -1 do (Z)

 

[AhoyNC]

Change the AND part of your formula to:

AND(MU2265>=-1,[COLOR=#ff0000]MU2265<=1[/COLOR])

[FONT=Lucida Grande]=IF(AND[COLOR=#006107]([/COLOR][COLOR=#0057d6]MU2265[/COLOR]>=-1,[COLOR=#0057d6]MU2265[/COLOR][COLOR=#ff0000]<[/COLOR]=1[COLOR=#006107])[/COLOR],[COLOR=#006107]$B$3[/COLOR]/[COLOR=#ab30d6]MO2265[/COLOR],IF[COLOR=#006107]([/COLOR][COLOR=#0057d6]MU2265[/COLOR]>1,[COLOR=#a54a29]$B$4[/COLOR]/[COLOR=#ab30d6]MO2265[/COLOR],IF[COLOR=#ab30d6]([/COLOR][COLOR=#33af4a]MU2256[/COLOR]<-1,[COLOR=#a54a29]$B$4[/COLOR]/[COLOR=#ab30d6]MO2265[/COLOR],[COLOR=#ab30d6])[/COLOR][COLOR=#006107])[/COLOR])[/FONT]

 

[ukmikeb]

Hi

Alternatively :-

=IF(ABS(MU2265)>1,$B$4,$B$3)/MO2265

or

=OFFSET($B$3,--(ABS(MU2265)>1),,)/MO2265

both of which are shorter than the original.

hth