IF Function in Excel error [Solved]

AngelaTyq 3 Posts Monday December 11, 2017Registration date December 12, 2017 Last seen - Dec 11, 2017 at 11:12 PM - Latest reply: AngelaTyq 3 Posts Monday December 11, 2017Registration date December 12, 2017 Last seen
- Dec 12, 2017 at 10:53 PM
Hello,
anyone can tell me where the error Is.
=IF(G:G>="0:05", 0:30Min, IF(G:G>="0:20",1:30hrs, IF(G:G="0:00",0:00hrs , 4:00hrs)))


*
      • if >0:05 ,show 0:30min
      • if >0.20 , show 1:30hrs
      • if =0, show 0:00hrs
      • if other ,show 4:00hrs





Thanks a lot.
See more 

3 replies

Reply to this topic
Mazzaropi 1695 Posts Monday August 16, 2010Registration dateContributorStatus January 19, 2018 Last seen - Dec 12, 2017 at 08:12 AM
0
Helpful
2
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
AngelaTyq 3 Posts Monday December 11, 2017Registration date December 12, 2017 Last seen - Dec 12, 2017 at 10:34 PM
First,thank for your helping .

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
AngelaTyq 3 Posts Monday December 11, 2017Registration date December 12, 2017 Last seen - Dec 12, 2017 at 10:53 PM
Also,i think bec of my cell E(value )lead cell G cannot calculate the "lateness"

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"
    • formula in my Cell E =IF(B:B="Friday",1.5, IF(B:B="Sunday",0, IF(B:B="Saturday",0,1)))
Respond to Mazzaropi