Formula

[hugoeloriginal]

Hi, I need a formula on F10 that automatically creates a number 0 on cell F10 when I put any number on cell F11

If you can help me please. Thank you!

 

[JamesW]

Hi,

Welcome to the board.

Try:

=IF(ISNUMBER(F11),0,"") - Not sure what you want if there isn't a number, so I've set it to "".

 

[hugoeloriginal]

FOR EXAMPLE: If I type 70 on F11, on F10 I need an automatic 0 or if I type 75 on F11, on F10 i need a 0 as well. Thanks

 

[JamesW]

Yeah I understood that bit, hence the formula I provided..