JE McGimpsey
I'm sorry I guess I'm not explaining myself correctly. I know you ar
trying to help and I hope I'm not wasting your time.

The function:
=IF(D7="RED",G7,0)
Tells me that if D7 is red copy the value of G7 in this cell
My problem is if it dosn't meet that condition I want it to post a $
value
It's probably something small I am overlooking I just can't seem to ge
it right

--
Message posted from http://www.ExcelForum.com