show overage of a cell
 

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

how do i set this up?

show overage of a cell
 

=abs(a1-38)

in B1, perhaps?

--
---
HTH

Bob

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



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

how do i set this up?

show overage of a cell
 

is this what you're looking for:
=A1-38, assuming the cell value is in A1.

-Chad

"diane" wrote:

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

how do i set this up?