Thread: Getting the difference between a "negative" number and a positive
View Single Post
  #2   Report Post  
Mazzaropi Mazzaropi is offline
Senior Member
  
Location: Belo Horizonte, Brazil
Posts: 170
Default
Mike Cadena, good evening.

Try to use this one:
=IF(A1<B1,A1+10000000,A1-B1)

Is it what you want?
__________________
I hope it can help you.

Best regards,
Marcilio Lobão
---------------------------
Belo Horizonte, Brazil
Reply With QuoteReply With Quote