Excell rejects my formula, how do I fix this one?

  • Thread starter Thread starter sonar
  • Start date Start date
S

sonar

Hi, I have a problem making this formula work, I cant find the problem
and excell keeps promting me to fix a problem, can anyone help?


=IF((CD17)<>"",0,

(if(CB17>(IF(OR(BW17=0,BX17=0),0,(IF(BW17<TIME(7,0,0),TIME(7,0,0)-BW17,0))+(IF(BX17>TIME(19,0,0),BX17-TIME(19,0,0),0))))),0


(IF(OR(BW17=0,BX17=0),0,IF(BW17<TIME(7,0,0),TIME(7,0,0)-BW17,0))+(IF(BX17>TIME(19,0,0),BX17-TIME(19,0,0),0)))-CB17)

)

regards
Sona
 
Hi sonar

try
=IF((CD17)<>"",0,(IF(CB17>(IF(OR(BW17=0,BX17=0),0,(IF(BW17<TIME(7,0,0),TIME(
7,0,0)-BW17,0))+(IF(BX17>TIME(19,0,0),BX17-TIME(19,0,0),0)))),0,(IF(OR(BW17=
0,BX17=0),0,IF(BW17<TIME(7,0,0),TIME(7,0,0)-BW17,0))+(IF(BX17>TIME(19,0,0),B
X17-TIME(19,0,0),0)))-CB17)))

this takes one bracked out from the end of(if(CB17>(IF(OR(BW17=0,BX17=0),0,(IF(BW17<TIME(7,0,0),TIME(7,0,0)-BW17,0))+(
IF(BX17>TIME(19,0,0),BX17-TIME(19,0,0),0))))),0,


and adds it to
)
Click to expand...

let us know how you go

Cheers
julieD
 
Hi

I need your help again.

With this formula that we fixed, when the amount displayed in my CB1
is the same value displayed in my formula for CC17:

(IF(OR(BW17=0,BX17=0),0,(IF(BW17<TIME(7,0,0),TIME(7,0,0)-BW17,0))+(IF(BX17>TIME(19,0,0),BX17-TIME(19,0,0),0)))),0,(IF(OR(BW17=0,BX17=0


which calculats my night hours. It freeks out


How can I instead of using the > sign as in my formula

=IF((CD17)<>"",0,(IF(CB17
(IF(OR(BW17=0,BX17=0),0,(IF(BW17<TIME(7,0,0),TIME(7,0,0)-BW17,0))+(IF(BX17>TIME(19,0,0),BX17-TIME(19,0,0),0)))),0,(IF(OR(BW17=0,BX17=0),0,IF(BW17<TIME(7,0,0),TIME(7,0,0)-BW17,0))+(IF(BX17>TIME(19,0,0),BX17-TIME(19,0,0),0)))-CB17)))

to an > and equal to CB18 to give me " "
 
Back
Top