Cell values in the "IF" function

[manashe123]

I am New to this so I will try to explain myself.
I have an IF function and want it to Return a 0 if false and a cell value if true. I get it to work BUT it Returns the CELL Number NOT the value in the cell.
What have I done wrong.

=IF((H16<0);"k16";"") This gives me k16 NOT 1000 which is the value in the cell.

It is 2010 Version

Thanks

 

[shobolos]

Replace "k16" with just k16 i.e. without the speech marks

 

[gaz_chops]

Welcome to the forum.

Remove the " from the formula -

=IF((H16<0);k16;"")

 

[manashe123]

Hi Guys
I can only thank you very much. I must have been sleeping. I was in hospital for 2 weeks With a heart problem but it has slowed me Down and i am not thinking so well.
manashe 123

 

[gaz_chops]

You're welcome, get well soon.