Is it possible for one cell to calculate two seperate totals based on the
calculation in other cells. I've already set the cells below to auto
calculate. I now want cell B38 to remain blank if B35 has an entry of a
dollar amount paid but I want it to display the total left if D37 and or E37
has a dollar amount entry.
Example:
funds left over are 500.00 in cell B28
required amount to be paid is 764.00 in B34
payment was made of 500.00 entered in B35
balance left is auto calculated in B36

Thanks