Thread: Need to supress display of FALSE in a cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
akkrug akkrug is offline
external usenet poster
  
Posts: 34
Default Need to supress display of FALSE in a cell
I have entered a formula that seems to work ok, but is displaying false if an
invalid code is entered into one of the input cells. Is there any way to
suppress the display of FALSE and just display spaces?

The formula in question is as follows:
=IF(I17="LH",(SUM(I28:M29)*30),IF(I17="OH1",(SUM(I 28:M29)*90),IF(I17="OH2",(SUM(I28:M29)*90),IF(I17= "EH1",(SUM(I28:M29)*120),IF(I17="EH2",(SUM(I28:M29 )*120))))))

Thanks for the help!!

Ken K. - 2191
--
akkrug
Reply With QuoteReply With Quote