 • 442K Members
• 10.2K Online
• 530K Conversations
SOLVED

# 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

# 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))))
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))
)``````

# Re: Need help with a complicated formula

@Sergei Baklan thank you so much it works perfectly

# Re: Need help with a complicated formula

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

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies