I presume =AVERAGE(B3:B15) is in B16? How is that calculation formatted? As
a decimal?

Try replacing the percentages in your formula with their decimal
equivalents, i.e., 0% = 0, 96% = .96, etc.


--
Brevity is the soul of wit.


"Karen" wrote:

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