Don
Your right but as the cell holds a percentage value it will never go over 100.
Also as you suggested above I have corrected the first equation in the chain
with
=IF(OR(L30="",H30=""),"",(L30/H30)*100) - which now doen't give an error.
So I can probably adjust the last equation to suit now.
Thnaks anyway
Don Guillett wrote:
Except if there is a 0 or a <0 or a 100 in the list. Is that what you want?
Or, do you just want to remove the div/0 cells?
Driller,
[quoted text clipped - 13 lines]
happy holiday
mine driller
--
Message posted via
http://www.officekb.com