pulling value from different worksheet in IF function

[andydufrane53]

I am trying to use cell from different worksheet as value in IF function. I keep getting this "the name that you entered is not valid". Am I approching this correctly? How do I fix this?

This is my example formula I'm entering into a cell on sheet1:

=If(sheet2!D4>=0,[!D4,0])

[tigeravatar]

andydufrane53,

I don't know what the brackets are trying to do. You would need to list the sheetname each time you reference a cell on a different sheet, like so:
=IF(sheet2!D4>=0,sheet2!D4,0)

That formula can be condensed using MAX():
=MAX(sheet2!D4,0)

[andydufrane53]

This works perfectly.....thx for the shortcut, a great help!