Add superscript to number then sum

  • Thread starter Thread starter CDunwood
  • Start date Start date
C

CDunwood

Has any one added a superscript to a number then sum and
the value displayed without the super script. see below

63.29 2 (want the 2 to display as a super script)
20.00
-------
83.92 (without the suberscript)

Need the field to be formated as numbers so I can
calculate the values

Help Cathy
 
Hi Cathy,

There are a few ways to do this, here's one:

A4 = 63.292 (2 is superscript)
A5 = 20.00

=VALUE(--A4)+A5 and format as number with 2 decimal places.

Biff
 
Back
Top