How to simplify this IF formula

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
<[email protected]> 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" <[email protected]> wrote in message
news:[email protected]...
> 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

Did you ever used Variables in Excel. That mean's that u can assign a cell, a formula to a Name of your choice. First it makes in a long formula, easyer to understand. And for people who like to used very very very long formula (that reach the 255 max caracters in a cell), u can over come that by doing so. And anaother thing, if this variable is a formula, and u have used it quite a bit in your excel file, it makes your calculation much faster. Because it only makes that calculation once insted of doing it many time. Witch brings me to your exemple:

=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)))

U r repeating twice this: 365/4000 and also $B$13*$B$75. It could be replace as variables that makes sens to you.

Now, i think that u shorten anough your formula, but it's difficult to see if it could be shrink some more if we dont see completely what u are trying to achive.

Ho yeah! to create a variable u go in: INSERT, NAME, DEFINE...

Et voila ! that mean's: tada !

Phil