show overage of a cell

D

diane

i need to show the difference between $38.00 and what is actually put in a
certain cell.

how do i set this up?
 
B

Bob Phillips

=abs(a1-38)

in B1, perhaps?

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Top