If statement (2000/2003)

Topic

New Reply

Hello,
I want to create an if statement in a cell, however, I want the if statement to look up to see if a sheet is currently present and if it is then take cell a1 of the sheet (advance) and multiply by 25%, if it is not, then just leave blank. Basically I have a worksheet with two sheets. The third sheet is going to be created if an advance is made via a macro. I want this formula to look into newly created sheet, see if it is there, and use cell a 1 for advancement amount. Any ideas?

Reply | Quote

Replies

Hi,
Try:
=IF(ISERROR(INDIRECT(“advance!A1″)),””,INDIRECT(“advance!A1”)*.25)
Hope that helps.

Reply | Quote

Thanks that works.

Reply | Quote