Thread: Another IF statement needed
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ChrisJ ChrisJ is offline
external usenet poster
  
Posts: 6
Default Another IF statement needed
=if(isnumber(N5),"",$L$1-G5)
--
ChrisJ
Omaha


"Connie Martin" wrote:

In M5 I need to add to the existing formula of =$L$1-G5 this: If there is
any number at all in N5, then M5 will be blank, otherwise it will calculate
$L$1-G5.
Reply With QuoteReply With Quote