Question how to set up an IF statement

[scott14]

How would you structure this?

Have 12 cols and about 7000 rows.

Every cell in col 1 has a dollar amount.
Every cell in col 2 has a constant, like the number 3 or 7 or other number.

In the other 10 cols, most cells are blank, but several thousand cells scattered randomly each contain the letter "x".

Want to replace every "x" in col 3 to col 12 with the answer of a very simple calculation. That's the $ in col 1 divided by the constant in col 2. If a cell is blank, it must remain blank.

This does NOT work:
=IF(NOT(ISBLANK),dollars/constant,"")
If the cell is not blank, then put here the dollars divided by the constant, else leave the cell blank.

This does NOT work:
=IF(isblank,"",dollars/constant)
If the cell is blank, leave it blank, else put here the dollars divided by the constant.

Thanks.

 

[bensonsearch]

I would simply go to find and replace (under edit)

find what is x

replace with

=dollars/constant

should work

 

[scott14]

bensonsearch,

Well that's absolutely amazing!

I never would've thought of what you suggested in a million years.
It works!
Thank you!

 

[bensonsearch]

bensonsearch,

Well that's absolutely amazing!

I never would've thought of what you suggested in a million years.
It works!
Thank you!

no problems at all glad to help