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

Numbers in column A so in column B:

=if(A1="","",IF(A1<60,A1*7,A1))

HTH

"steve" wrote:

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

This should work.

If it's 60 or less just change to <=60.

=IF(A1<60,A1*7,A1)

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=567194

"steve" wrote in message
...
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.


You are not making a suggestion, are you, you are asking a question so WHY
CHECK THE SUGGESTION BOX?