Try:

=IF(G28<0,0,IF(K280,G28,G28/2))

and format the cell as Accounting with no currency sign if necessary but
note that the value stored in the cell will now be zero.

--
HTH

Sandy

Replace@mailinator with @tiscali.co.uk


"Admiral70" wrote in message
ups.com...
This works good, now what if G28 is a negative number. Is there a way
to modify the following formula to not show a negative and instead show
a - (dash)?

=IF(K280,G28,G28/2)