Thread: Count if a number in a cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
JC-PS JC-PS is offline
external usenet poster
  
Posts: 29
Default Count if a number in a cell


"JC-PS" wrote:


=IF(L8="",G8<0,IF(M7<0,-M7*D2*2,L8)) any how working better
even when M7 is a negative or a positive number, incl 0. ;D
A correction,
=IF(L8="",G8<0,IF(G7<0,G7*D2*2,L8)), much better :D
Reply With QuoteReply With Quote