Max, thanks for her help. I ended up utilizing the VLOOKUP and it was much
cleaner!
--
Thanks for your assistance!

Karen


"Max" wrote:

Think you have a gap in this term:
... AND(' Yrly Log'!B16=1.01,' Yrly Log'!B16<5),..

which should be replaced by:
.. AND(' Yrly Log'!B16=1,' Yrly Log'!B16<5), ..

Try either:
=IF((AND(' Yrly Log'!B160,' Yrly Log'!B16<0.96)),1,
IF((AND(' Yrly Log'!B16=0.96,' Yrly Log'!B16<0.97)),2,
IF((AND(' Yrly Log'!B16=0.97,' Yrly Log'!B16<0.99)),3,
IF((AND(' Yrly Log'!B16=0.99,' Yrly Log'!B16<=1)),4,
IF((AND(' Yrly Log'!B16=1,' Yrly Log'!B16<5)),5,"")))))

Or, perhaps its neater & better to do it with a VLOOKUP:
=VLOOKUP(' Yrly Log'!B16,{0,1;0.96,2;0.97,3;0.99,4;1,5;5,""},2)

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Karen" wrote:
I have the following formula that I've enterd in a spreadsheet that returns a
blank when the reference field contains a formula. If I substitue the
formula for a percentage, it returns the correct value. How can I fix this?

=IF((AND(' Yrly Log'!B160,' Yrly Log'!B16<0.96)),1,IF((AND(' Yrly
Log'!B16=0.96,' Yrly Log'!B16<0.97)),2,IF((AND(' Yrly Log'!B16=0.97,' Yrly
Log'!B16<0.99)),3,IF((AND(' Yrly Log'!B16=0.99,' Yrly
Log'!B16<=1)),4,IF((AND(' Yrly Log'!B16=1.01,' Yrly Log'!B16<5)),5,"")))))

Formula in 'Yrly Log'!B16 is =AVERAGE (B3:B15) value is 101%. Doesn't seem
to matter if format of B16 is decimal or %.

--
Thanks for your assistance!

Karen