Thread: Formula Question
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey JE McGimpsey is offline
external usenet poster
  
Posts: 4,624
Default Formula Question
One way:

=IF(A2=A1,"",A2-A1*24)

In article .com,
wrote:

I have a formula (geared towards adding up my project hours) that
reads, =A2-A1*24. This works fine. However, in addition, I need it
to also say if the result is zero then it should have a null value.
Is this possible?
Reply With QuoteReply With Quote