I need a formula for column D that only affects cells in column C that have dollar values. I don't want to end up with a lot of errors as column C is formatted with text, borders, filled cells, empty cells, etc. So I need the dollar values to be divided by 4 and populated into column d. Please help as this list is terribly long and I don't want to manually manipulate it. There is an attachment showing column C....basically, I want all of the formatting, etc. from column C copied over to column D but I want the cells with dollar values to be divided by 4.
Bookmarks