Formula help, not sure what kind

[royhern]

Team, I am trying to get a "new" formula in cell B3 that if I type a number in cell C3, then the answer in B3 needs to be 0. The current formula in cell B3 is =(A3/5.5)*3.1

Thanks for the help.

Roy

 

[tyija1995]

Try this in cell B3:

=IF(ISNUMBER(C3),0,"Placeholder")

 

[royhern]

Try this in cell B3:

=IF(ISNUMBER(C3),0,"Placeholder")

Thanks for the fast response!!!

oops maybe I didn't explained myself clear.. the original formula in B3 must remain in the cell which is =(A3/5.5)*3.1 and it currently shows a number but when I key in a number in C3 then B3 must equal 0.... can this be done? thanks

 

[t0azt]

Thanks for the fast response!!!

oops maybe I didn't explained myself clear.. the original formula in B3 must remain in the cell which is =(A3/5.5)*3.1 and it currently shows a number but when I key in a number in C3 then B3 must equal 0.... can this be done? thanks

Just replace the "Placeholder" from Tyija's formula with your original formula.

 

[royhern]

AWESOME!!! works great... thank you