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