a cell in excel will not display the formula total

  • Thread starter Thread starter John
  • Start date Start date
J

John

my formula is P190 = sum(P129+P189)...P129 and P189 have money entries. P190
just keeps displaying a $ sign but no number totals. What am I doing wront?
 
John,

= sum(P129,P189) will work you don't need the plus but equally that won't
cause your problem either. Do you have formatting on the cell? if so delete
it and try again.

A Custom format of $ would give the symptoms you describe.

Mike
 
John,

= sum(P129,P189) will work you don't need the plus but equally that won't
cause your problem either. Do you have formatting on the cell? if so delete
it and try again.

A Custom format of $ would give the symptoms you describe.

Mike
Click to expand...

Or if P129 and P189 are Text instead of Values.
 
Back
Top