Microsoft Office Forums Need help with IF formulas for work timesheets
 Register FAQ Search Today's Posts Mark Forums Read

#1
01-17-2023, 07:26 PM
 Tash14 Windows 10 Office 2021 Novice Join Date: Jan 2023 Posts: 2
Need help with IF formulas for work timesheets

Hi Everyone,

I need help please. I want to add a formula but not sure how to do it, i googled but its not giving me the info I need.

in our timesheet excel i have made i want to ad the following:

1. IF the employee worked 8 hours the value should be 7.6 (if its less it should show what the value is) I got the 1st part but not the second it just gives me the word FALSE

2. IF it is 8 hour (7.6) then he should get 0.4 is it is not 8 then is should be 0

So basically what I want it to do is the following:

If you worked 8 hours then it is 7.6 + 0.4 = 8
if you worked less than 8 hours it is jut 7.6 + 0 = 7.6

I don't know how to do this in excel.

Please see attached what i have done.

Thanks
Tash
Attached Files
 Help .xlsx (13.7 KB, 1 views)
#2
01-17-2023, 08:44 PM
 Guessed Windows 10 Office 2016 Expert Join Date: Mar 2010 Location: Canberra/Melbourne Australia Posts: 3,380

The If formula has three parts: Test,ValueIfTrue,ValueIfFalse. You only provided a ValueIfTrue so when the False state is triggered you didn't tell the formula what to do. That is fixed by adding that to the formula in cell F6
=IF(H6>=7.6,7.6,H6)

But I would use a simpler formula in cell F6 and then copy it down
=MIN(7.6,H6)
That will give you the actual hours up to a maximum of 7.6
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
#3
01-18-2023, 03:31 PM
 Tash14 Windows 10 Office 2021 Novice Join Date: Jan 2023 Posts: 2

Hi Andrew,

Thank you so much for helping me out, if I get stuck again Ill just shout out.

Thanks
Tash

 Thread Tools Display Modes Linear Mode

 Similar Threads Thread Thread Starter Forum Replies Last Post dave6084 Mail Merge 1 11-02-2019 11:01 PM Martin_Ko PowerPoint 0 10-05-2017 05:57 AM Campelliann Project 1 01-09-2017 06:15 PM Will Excel 1 09-28-2016 09:12 AM eekoh Misc 0 02-24-2015 07:57 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:17 AM.

 -- Default Style -- Lightweight -- New Mobile Contact Us - Privacy Statement - Top