• 545K Members
• 3,384 Online
• 650K Conversations
SOLVED

## Need help with a complicated formula

Highlighted
Occasional Contributor

# Need help with a complicated formula

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

4 Replies
Highlighted

# Re: Need help with a complicated formula

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))))
Highlighted
Solution

# Re: Need help with a complicated formula

It could be

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

Highlighted

# Re: Need help with a complicated formula

@Sergei Baklan thank you so much it works perfectly

Highlighted

# Re: Need help with a complicated formula

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