Thread: If statement to replace #VALUE! code
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jeannie v jeannie v is offline
external usenet poster
  
Posts: 127
Default If statement to replace #VALUE! code
Hi Experts:

I know this is fundamental to formulas, but I'm doing something wrong..N20
returns #VALUE! if N21 is Blank......I want to it to state:

If Cell N21 is Blank, Insert 0:00:00

The existing formula that I want to add this statement to is:

=ROUND(TRIM(N21)*1440,0)/60

Can anyone help?
--
jeannie v
Reply With QuoteReply With Quote