Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

IF function in Excel error [Solved/Closed]

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

1 reply

Answer 1 / 1
Posts
1892
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
March 4, 2021
 142
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
Report
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
Report
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)))
Ask a question

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!