Formula Total

Hi, I have 3 columns, Amount A, Amount B and Total.

A is a formula pulling a dollar amount from another cell

B is an amount entered manually

Total is the total of those two, Total is =MAX formula (so I don’t see an amount less than 0.

 

Question; How do I get the “Total” column to show blank until a figure is entered into B?

 

 Amount A   Amount B   Total 
 $         2,470.00  $          1,150.00  $                    1,320.00
 $         2,470.00    $                    2,470.00
 $         2,470.00    $                    2,470.00
 $         2,470.00    $                    2,470.00
 $         2,470.00    $                    2,470.00

By: Clayton

Leave a Reply

Your email address will not be published. Required fields are marked *