Multiplying Values only less than 1.5
Hi,
I have a column of cells that are using if() and vlookup() to pull numbers from elsewhere. I need excel to, in a separate cell, multiply all of the values from these cells that are less than 1.5. But some of the values are greater than 1.5, and I need those not to be a part of the multiplication. Any help would be appreciated. -AC |
Multiplying Values only less than 1.5
"Amanda Kenner" wrote:
I have a column of cells that are using if() and vlookup() to pull numbers from elsewhere. I need excel to, in a separate cell, multiply all of the values from these cells that are less than 1.5. But some of the values are greater than 1.5, and I need those not to be a part of the multiplication. When you have a question like this, it is always expeditious to provide concrete examples of the formulas, at the very least. Even better: upload an example Excel file to a file-sharing website and post its uRL. (ExcelBanter might allow you to attach the Excel file. I don't know.) Generally, if the result of the IF/VLOOKUP expression is in A1, then in B1, you might write: =IF(A1<1.5,A1*3,A1) But the devil is in the details. For example, what to do if it is empty or the null string ("")? And what to do if A1 is __equal_to__ 1.5? Finally, what about values in A1 that __look_like__ they are 1.5 due to formatting, but in fact, they are less than 1.5 (e.g. 1.49)? |
All times are GMT +1. The time now is 04:55 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com