View Single Post
  #24   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DAI via OfficeKB.com DAI via OfficeKB.com is offline
external usenet poster
 
Posts: 6
Default Average If (Value between 1 and 100)

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