Forum Discussion

Copper Contributor

May 22, 2018

Solved

Formulas

I need to calculate daily totals based on the following <3,35 hours at 20 >=3,36 and <=4,45 hours at 40 >=4,46 hours at 60 Thanks for the help Antonio

Formulas & Functions

Need Help

Matt Mickle
May 23, 2018
Antonio-

After reviewing your file I believe one of these formulas will work:

IF Formula: =IF(B4<=3.35,20,IF(B4<=4.45,40,60))

IFS Formula: =IFS(B4<=3.35,20,B4<=4.45,40,TRUE,60)

**IFS is applicable for: Excel for Office 365 Excel for Office 365 for Mac Excel 2016 Excel 2016 for Mac Excel Online Excel for iPad Excel for iPhone Excel for Android tablets Excel for Android phones Excel Mobile

Please see the attachment for reference.

TieredHoursFormulas.xlsx11 KB

António Barbacena

Copper Contributor

May 23, 2018

I Matt

I 'll send the data sheet that I need

Thanks

António

Book1.xlsx8 KB

Matt Mickle

Bronze Contributor

May 23, 2018

Antonio-

After reviewing your file I believe one of these formulas will work:

IF Formula: =IF(B4<=3.35,20,IF(B4<=4.45,40,60))

IFS Formula: =IFS(B4<=3.35,20,B4<=4.45,40,TRUE,60)

**IFS is applicable for: Excel for Office 365 Excel for Office 365 for Mac Excel 2016 Excel 2016 for Mac Excel Online Excel for iPad Excel for iPhone Excel for Android tablets Excel for Android phones Excel Mobile

Please see the attachment for reference.

TieredHoursFormulas.xlsx11 KB

António Barbacena
Copper Contributor
May 23, 2018
Thanks Mark! For your topics.
- Matt Mickle
  Bronze Contributor
  May 23, 2018
  Antonio-
  
  Glad you were able to get it working. You're, welcome. Please feel free to post back to the community if you have additional inquiries.