Jul 26 2019 09:32 AM
So I cant seem to figure out how to make this work. i have 2 formulas i need to use in a sheet i am making. column A will have 3 options
Type | Weight | Total |
1 | 500 | |
2 | 500 | |
3 | 500 |
formula will be the same for type 1 and 2
=IF((A1*0.033)>50,((50)),IF((A1*0.033)<15,((15)),((A1*0.033))))
and 3 will be
=IF((FA1*0.033)>35,((35)),IF((A1*0.033)<10,((10)),((A1*0.033))))
i need to make the last column recognize which formula to multiply weight by depending on whether its 1, 2 or 3 in first column
Jul 26 2019 09:42 AM
Jul 26 2019 10:04 AM
SolutionJul 27 2019 01:23 PM
@Sergei Baklan thank you so much it works perfectly
Jul 28 2019 07:58 AM
@Jethro323 , you are welcome. If you don't mind I moved "best response" on the answer
Jul 26 2019 10:04 AM
SolutionIt could be
=IF(A1<3,
MIN(50,MAX(15,B1*0.033)),
MIN(35,MAX(10,B1*0.033))
)