I have entered the following formula and it keeps giving me a blank when the
reference field is a formula. If I change to a number it will populate. Can
someone tell me what I'm doing wrong?

=IF((AND(' Yrly Log'!B160%,' Yrly Log'!B16<96%)),1,IF((AND(' Yrly
Log'!B16=96%,' Yrly Log'!B16<97%)),2,IF((AND(' Yrly Log'!B16=97%,' Yrly
Log'!B16<99%)),3,IF((AND(' Yrly Log'!B16=99%,' Yrly
Log'!B16<=100%)),4,IF((AND(' Yrly Log'!B16=101%,' Yrly
Log'!B16<500%)),5,"")))))


If the cell it points to is: =AVERAGE(B3:B15) the result is a blank.

--
Thanks for your assistance!

Karen