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?
<colgroup><col _mce_style="mso-width-source: userset; mso-width-alt: 3437; width: 71pt;"><col _mce_style="mso-width-source: userset; mso-width-alt: 3547; width: 73pt;"><col _mce_style="mso-width-source: userset; mso-width-alt: 4681; width: 96pt;"></colgroup><tbody>
</tbody>
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 |
<colgroup><col _mce_style="mso-width-source: userset; mso-width-alt: 3437; width: 71pt;"><col _mce_style="mso-width-source: userset; mso-width-alt: 3547; width: 73pt;"><col _mce_style="mso-width-source: userset; mso-width-alt: 4681; width: 96pt;"></colgroup><tbody>
</tbody>