Is it possible to create a formula that shows a 0 when the total is a minus after a calculation ?
Let me explain .
Cells a1 to a12 is Jan to Dec
Cells c1 to c12 is monthly use
Formula in say cell c2 is ( +a2-a1) , cell c3 is ( +a3-a2 )and so on across to c12 which will then give a negative value in the following c cell ( cell c3 ( +a3-a2 ) ) then shows a negative value in cell c4 as the months go by . so the formula that I am after is say where March figure ( a3 ) is inserted giving a monthly use in c3 , and there is no entry in April ( a4 ) the negative figure is shown in cell c4 . I would like this c4 cell to show 0 .
May I thank you in anticipation of your assistance
Franky
Franky,
Please read the forum rules below then amend your title to be more descriptive
VBA Noob
_________________________________________
![]()
![]()
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks