formula help for excel
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 |
formula help for excel
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 |
formula help for excel
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 |
formula help for excel
"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? |
All times are GMT +1. The time now is 06:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com