Thread: Nested IF functions beyond eight items?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
vezerid vezerid is offline
external usenet poster
  
Posts: 751
Default Nested IF functions beyond eight items?
Hi Bob,

I guess I have been rusty too long. Actually nice idea for an
assignment <wide evil grin.

Kostis

Bob Phillips wrote:
small change for negatives Kostis

=CEILING(MAX(A12,0),5)/2


--
HTH

Bob Phillips


Reply With QuoteReply With Quote