Function help?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I keep getting: #Value! in the empty cells if there is no data. Please check my function for issues, 'cause it keeps coming up with the #VALUE! error if there is no data. Here it is:
=IF(AG11+AH11=0,"",IF(U11+V11=0,"",((AG11+AH11)-(U11+V11))))*24*6

Thanks,
 
Terry,

You multiply by 24*60 regardless of what you found, this gives the #VALUE on
empty cells. Try this alternative

=IF(AG11+AH11=0,"",IF(U11+V11=0,"",((AG11+AH11)-(U11+V11))*24*60))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Terry said:
I keep getting: #Value! in the empty cells if there is no data. Please
Click to expand...
check my function for issues, 'cause it keeps coming up with the #VALUE!
error if there is no data. Here it is:
 
Terry,

The problem is that if your data is empty, you in the formula multiply ""
with 24*60.

Change the formula to :
=IF(AG11+AH11=0,"",IF(U11+V11=0,"",((AG11+AH11)-(U11+V11))*24*60))

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *

Terry said:
I keep getting: #Value! in the empty cells if there is no data. Please
Click to expand...
check my function for issues, 'cause it keeps coming up with the #VALUE!
error if there is no data. Here it is:
 
move the last two brackets to the outside

=IF(AG11+AH11=0,"",IF(U11+V11=0,"",((AG11+AH11)-(U11+V11))*24*60))
Bill K

Terry said:
I keep getting: #Value! in the empty cells if there is no data. Please
Click to expand...
check my function for issues, 'cause it keeps coming up with the #VALUE!
error if there is no data. Here it is:
 
To add to Bob's answer <vbg> :
It looks as if you are busy with some timecalculations. If the cell in
which this formula is contained is formatted as time and so are AG11,
AH11,U11 and V11, make sure then that ((AG11+AH11)-(U11+V11) > 0. Excel
won't accept negative timevalues.

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 
=IF(SUM(AG11:AH11)="",0,IF(SUM(U11:V11)=0,"",(SUM(AG11:AH11)-SUM(U11:V11))*2
4*60))

--
Regards,
Tom Ogilvy


Terry said:
I keep getting: #Value! in the empty cells if there is no data. Please
Click to expand...
check my function for issues, 'cause it keeps coming up with the #VALUE!
error if there is no data. Here it is:
 
-----Original Message-----
I keep getting: #Value! in the empty cells if there is no
Click to expand...
data. Please check my function for issues, 'cause it keeps
coming up with the #VALUE! error if there is no data. Here
it is:
=IF(sum(AG11:AH11)=0,"",IF(sum(U11:V11)=0,"",((AG11+AH11)- (U11+V11))*24*60

Thanks, 1 2
.>=IF(sum(AG11:AH11)=0,"",IF(sum(U11:V11)=0,"", ((AG11+AH11)-(U11+V11))*24*60

try my corrected formula . Note that if either condition
Click to expand...
1 or 2 is correct, you will get 0 as answer. Fiure out
which one is the essitial info and use that as the
condition.

Luke
 
Back
Top