View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
Tushar Mehta
 
Posts: n/a
Default ADD NEGATIVE NOT POSATIVE

By 'Net convention, using all capitals is the equivalent of shouting.
You may want to keep that in mind for future posts.

It is not clear what exactly you want, but may what you want is in A50
the formula =A35+MIN(A1,0)

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
EXAMPLE..
A1:(295.00) A35:295
A1:295 A35:295
A50=A1:(295)+A35:
IF A1: IS A POSATIVE NUMBER DO NOT ADD TO A35: BUT IF A1:IS A NEGATIVE
NUMBER ADD TO A35: