dear readers,
I have a question regarding excel formula. I have a column filled with
numbers. some of the cells in this column do not have any values and are
empty. I want to multiply the numbers in this column with a digit say 7 so
that the result appears in the next column. But only numbers having value
below 60 should be multiplied,or else the same number should appear in the
next column. for instance if numerical is 70,then the same should appear in
the next column,if 40 then 280.could some one suggest me a formula.
appreciate your help
thanking you
steve

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc