Thread: =IF(AND(B1D1)=C1*-1,IF(AND(D1B1)=C1*1))
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
RA RA is offline
external usenet poster
  
Posts: 53
Default =IF(AND(B1D1)=C1*-1,IF(AND(D1B1)=C1*1))
How about this?

=IF(B1D1,((B1-D1)/D1)+1,(((B1-D1)/D1)+1)*-1)
Reply With QuoteReply With Quote