Log In
Register
Home
Active Member
August 25, 2020
Offline
I am trying to assign a value to an excel spread sheet. Here's the example; Columns A & B need to be added in Column C (A1+B1=C1).
If the Value of C1 >0 AND <=60 then I need to Pull from another Column a Value in Column D to be Multiplied by the Value in Column E.
I need to perform this calculation for intervals of 5. Example 60,65,70. Can anyone please help?
October 5, 2010
Offline
Hi Jim,
Please read
https://www.myonlinetraininghu.....this-first
Please attach your workbook. Without your workbook it makes it more difficult to visualize and recreating your data will be prone to error.
Regards
Phil
Active Member
August 25, 2020
Offline
Thanks for the response. I just uploaded my excel file
October 5, 2010
Offline
Thanks Jim,
The workbook doesn't match up with your description of what you are trying to do. There's nothing in Column C. Col B contains text so can't be added to anything?
Regards
Phil
Active Member
August 25, 2020
Offline
I am trying to assign a value to an excel spread sheet. Here's the example; Columns A & B need to be added in Column C (A1+B1=C1).
If the Value of C1 >0 AND <=60 then I need to Pull from another Column a Value in Column D to be Multiplied by the Value in Column I.
I need to perform this calculation for intervals of 5. Example 60,65,70. Can anyone please help?
October 5, 2010
Offline
Hi Jim,
You can use VLOOKUP to do this. I've modified the lookup table in Cols H:I in order that VLOOKUP will work correctly.
Your example lookup table increments in 10's not 5's so you'll need to adjust the lookup table accordingly.
see attached.
Regards
Phil
1 Guest(s)
