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?

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


On Fri, 4 Mar 2005 07:39:03 -0800, Bojana
wrote:

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?

Hi


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


Arvi Laanemets


"Bojana" wrote in message
...
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?