IF function in Excel error [Solved/Closed]

Report
Posts
3
Registration date
Monday December 11, 2017
Status
Member
Last seen
December 12, 2017
-
AngelaTyq
Posts
3
Registration date
Monday December 11, 2017
Status
Member
Last seen
December 12, 2017
-
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.

4 replies

Posts
1833
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
131
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
Posts
3
Registration date
Monday December 11, 2017
Status
Member
Last seen
December 12, 2017

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
Posts
3
Registration date
Monday December 11, 2017
Status
Member
Last seen
December 12, 2017

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)))