SOLVED

Need help with a complicated formula

Copper Contributor

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 

TypeWeightTotal

1

500

 

2

500 
3500 

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

4 Replies
should say B1
if type1 or 2
=IF((B1*0.033)>50,((50)),IF((B1*0.033)<15,((15)),((B1*0.033))))
if type 3
=IF((B1*0.033)>35,((35)),IF((B1*0.033)<10,((10)),((B1*0.033))))
best response confirmed by VI_Migration (Silver Contributor)
Solution

@Jethro323 

It could be

=IF(A1<3,
  MIN(50,MAX(15,B1*0.033)),
  MIN(35,MAX(10,B1*0.033))
)

 

@Sergei Baklan thank you so much it works perfectly

@Jethro323 , you are welcome. If you don't mind I moved "best response" on the answer

1 best response

Accepted Solutions
best response confirmed by VI_Migration (Silver Contributor)
Solution

@Jethro323 

It could be

=IF(A1<3,
  MIN(50,MAX(15,B1*0.033)),
  MIN(35,MAX(10,B1*0.033))
)

 

View solution in original post