Domenic's response looks like it might be a neater formula. Give it a
try.
I find the best way to do complex formulas (I also get the mush
problem!) is to build it up in different cells. You'd already created
the most complex part so keep that to one side.
Then in another cell (say A2 for sake of argument), do a simple IF
formula for just 2 of the conditions. e.g.
=IF(D35105%,"A","B")
Then in another cell (say B2) write the next part, i.e.
=IF(D35110%,"Exceeds Guidelines",A2).
Check both formulas work. Now combine them by copying
IF(D35105%,"A","B") from A2 and pasting it to where it says A2 in the
second formula, giving you
IF(D35110%,"Exceeds Guidelines",IF(D35105%,"A","B"))
AFter checking the combined formula works, replace "A" and "B" with the
bits of the formula you'd already worked out.
It's important to drop the initial '=' when you copy the formulas into
another formula.
Clive

sharkfoot Wrote:
That did it. My brain starts turning to mush after a couple of hours of
tinkering with the same formula. I appreciate your assistance and thank
you!


--
Clivey_UK
------------------------------------------------------------------------
Clivey_UK's Profile: http://www.excelforum.com/member.php...o&userid=32569
View this thread: http://www.excelforum.com/showthread...hreadid=528990