Newbie formula with Min,Max result

HashtagERROR

HashtagERROR

New Member
Joined
Apr 24, 2020
Messages
2
Platform
  1. Mobile
Monthly shift work that is variable with minimum guarantees and maximum payouts. The first paycheck is based off a value that is the average workers hours -2hrs. Never less than 72hrs, never more than 80hrs.

average hours -2 = 1st paycheck (min 72, max 80)

I am lost whether I can combine Min,Max functions, or if this is a IF equation with 3 possible solutions?

=max(B5-2,72)
=min(B5-2, 80)
=B5-2
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.
Sort by date Sort by votes
Bingo!

Thank you for your time Eric. Hopefully I can learn enough to give back in the future.
 
Upvote 0
You must log in or register to reply here.

Similar threads

A
  • Solved
Calendar form cancel button passing data to worksheet
Replies
7
Views
401
AndyEd
A
A
  • Solved
Calendar issue
Replies
1
Views
1K
AndyEd
A
L
  • Question
VBA works on work PC but not home PC
Replies
3
Views
2K
rollis13
rollis13
L
  • Question
Need help figuring out a formula to calculate prices based on 4 conditions
Replies
1
Views
1K
Legacy 483325
L
J
  • Solved
Combined Min & Max Nested Excel Formula
Replies
6
Views
4K
johnnie1
J

Forum statistics

Threads
1,215,059
Messages
6,122,917
Members
449,093
Latest member
dbomb1414

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top