Feb 24 2020 10:09 AM
I am trying to create a formula to fill a column where the variable in the equation is based off of the value in another column. i.e. column C can contain codes 01, 02, 03 ,04 ,05, 06, 07, 08. if column c is 02,03,06, or 07 the variable multiplier is .30 . IF c=02,03,06,07 then multiply column D Value by .30
If c = 01, 04, 08 then multiply column D value by .40. Place value in column M
Feb 24 2020 02:00 PM