How to simplify this IF formula

[Bojana]

All,

I have this formula:
=IF(C99>$B$61;0;
IF(C99=$B$19;(($B$13*$B$75)*$D$23/$E$23*365/4000);IF(C99>$B$19;(($B$13*$B$75)*365/4000);0)))

Is there a way to simplify it? The placement of data is fixed, I cannot
change the cells I am using.

Any ideas?

 

[Bob Tarburton]

Hey Bojana

Try this
=IF(OR(C99>$B$61,C99<$B$19),0,$B$13*$B$75*0.09125*IF(C99=$B$19,$D$23/$E$23,1))

note that substitutibg 0.09125 for 365/4000 doesn't save you much

 

[Arvi Laanemets]

Hi


=((C99=$B$61)*($D$23/$E$23)+AND(C99<$B$61;C99>$B$19))*($B$13*$B$75*365)/4000


Arvi Laanemets