Need help with an IF statement

[curlzndye]

Hello,

I am trying to use an IF statement that refers to another worksheet in a workbook.

Here is what it looks like:

=IF("ORDER!A24"="PV","='ORDER!B24'",0)

What I am trying to accomplish in the cell is this: If cell A24 in the ORDER worksheet is equal to PV, then I want the information from cell B24 in the ORDER worksheet to show up in the cell. If it is not equal to PV, then I want it to stay blank.

It is not working and I'm not sure why.

Any help would be greatly appreciated.

Thanks!!

 

[VoG]

Try

=IF('ORDER'!A24="PV",'ORDER'!B24,"")

 

[curlzndye]

Thank you so much!!!!!!!