IF function in Excel error
Solved/Closed
AngelaTyq
Posts
3
Registration date
Monday December 11, 2017
Status
Member
Last seen
December 12, 2017
-
Updated on Jan 28, 2018 at 09:50 AM
AngelaTyq Posts 3 Registration date Monday December 11, 2017 Status Member Last seen December 12, 2017 - Dec 12, 2017 at 10:53 PM
AngelaTyq Posts 3 Registration date Monday December 11, 2017 Status Member Last seen December 12, 2017 - Dec 12, 2017 at 10:53 PM
Related:
- IF function in Excel error
- Network error occurred - Guide
- Number to words in excel - Guide
- Cmos checksum error - Guide
- Gif in excel - Guide
- Marksheet in excel - Guide
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Dec 12, 2017 at 08:12 AM
Dec 12, 2017 at 08:12 AM
AngelaTyq, Good morning.
You lack information in your logic.
What happens if G3 is greater than 0 and less than 5?
What does other = 4:00 mean? Please give us an example.
If you save your spreadsheet on a free website, www sendspace.com and put the download link here , will be much faster and easier to help you.
I'm sure we can help you.
--
Belo Horizonte, Brasil.
Marcílio Lobão
You lack information in your logic.
What happens if G3 is greater than 0 and less than 5?
What does other = 4:00 mean? Please give us an example.
If you save your spreadsheet on a free website, www sendspace.com and put the download link here , will be much faster and easier to help you.
I'm sure we can help you.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Dec 12, 2017 at 10:34 PM
What happens if G3 is greater than 0 and less than 5?
Ans:If G3 less than 5 will be 0
What does other = 4:00 mean
Ans:If G3 no show any record (when employee no proper record their "in & out" will deducted 4 hours from their salary.
this are the table that help to cal. lateness of employee from lunch
if late from lunch
>0:05min ,show 0:30min (deduct half hours),but i only want to show 0:30min in Cell H
if >0.20min , show 1:30hrs
if <0:00min, show 0:00hrs(it meant they come back early or back from lunch on time)
if other ,show 4:00hrs (other meant no proper record,maybe "-",show in G3,will deducted 4 hrs
Dec 12, 2017 at 10:53 PM
To calculate the "lateness" should be Cell F(time value)- Cell E(General Value),
i can't set the Cell E into time value,
always show me "formula error"