applying IF function to a range of rells in an entire worksheet
Posted by Jeanette on April 08, 2001 1:43 PM
I want to apply the following formula to all the selected cells in my worksheet.
" if theres a dollar amount then divide it by 9"
Here's the formula I typed in =IF(E98:O98>1,/9,"")
which I understand to read if the contents of cells E98 to O98 are greater than 1,divide by 9,if it's not leave it blank.
when I put /9 I get the message invalid, yet if I just apply /9 to one cell it works. What am I doing wrong?