
Active Member

August 25, 2020

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

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

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?
1 Guest(s)
