dont calculate if no data present in 2 cells

[TMC1982]

this is the formula i have now.
=IF(ISNUMBER(G35)*(G34=F35),(G35-F35),IF(F35>0,(G35-F35+1),""))

I'm looking to find out how to make the calculation not calculate until data is entered in both F35 and G35

Thank you in advance for your assistance.

[José Augusto]

Try

=IF(AND(F35<>"",G35<>""),your calculation, "")

[PaulM100]

Like this maybe:

=IF(OR(G35="",F35=""),"",IF(ISNUMBER(G35)*(G34=F35),(G35-F35),IF(F35>0,(G35-F35+1),"")))

[TMC1982]

Thank you both for your assistance.

PaulM100 that formula worked perfectly. You the Man

[PaulM100]

Glad to help. Please mark the thread as Solved if that took care of you problem, from The Tools.