Forum Discussion
Need calculations help
I am trying to use an IF function with multiple calculations but sometimes one of the cell will contain a 0 and because it can't divide by zero it won't give me the time I need. So I have to go in a e...
You will love this when I go back to my example file on my laptop the @ isn,t there but the error is. I'm going to attach a photo
See if this works better (in F1, then fill down):
=IF(AND(G1=0,H1=0),"",(IFERROR(E1/G1,0)+IFERROR(E1/H1,0))/24)
or perhaps you'll prefer simply
=(IFERROR(E1/G1,0)+IFERROR(E1/H1,0))/24
- After a closer look the {} were missing and the ends of the statement. After adding those brackets it appears to be working. Thank you again