another simple formula

[smitty]

Thanks for the previous response.

I attempting a simple senario and would appretiate help
with the formula:

if((A1-B1)/(D1-E1))<25% and C1>D1,E1,"")

Could you please assist with the proper formula for above
info. Thanks.

 

[Andy B]

Hi

Try this:
=IF(AND(((A1-B1)/(D1-E3))<0.25,C1>D1),E1,"")

 

[Michael Malinsky]

=IF(AND((A1-B1)/(D1-E1)<25%,C1>D1),E1,"")

--
Michael J. Malinsky
Pittsburgh, PA

"I am a bear of very little brain, and long
words bother me." -- AA Milne, Winnie the Pooh

 

[Biff]

Michael J. Malinsky
Pittsburgh, PA

Are you the Mike Malinsky that worked at Southdown/Cemex ?

Biff