Formula problem between different Excel versions

[BlissC]

Hi,

I've got a formula which I'm using to populate the contents of cells in a column based on whether a date has been entered in a cell in the same row in an adjacent column. This is the formula:

=IF(ISNUMBER(T4),"Completed","Repair outstanding")

Basically, if there's a date in the cell in column T, in the cell in question display 'completed', but if the cell in column T is empty, display 'repair outstanding'. This works fine in a test spreadsheet that I set up on my home laptop to try out different formulae and conditional formatting, but I can't get it to work on the 'live' spreadsheet at work. The cell just shows the formula rather than either 'completed' or 'repair outstanding'. The only difference I can think of is that on my home laptop I have Excel 2016, and at work we're still on Excel 2010. Even then though, the test spreadsheet I set up at home with the formula in it still works fine running on my Excel 2010 at work - it just won't work on the 'live' spreadsheet, so I'm not sure whether it is a problem with different Excel versions, or a problem with the formula itself.

If anyone could offer any guidance on where to go with this, I'd be most grateful!

 

[JLGWhiz]

It is not the version. Select the cell with the formula, then click the fx symbol next to the formula bar at the top of the window. maybe that will give you a clue.

 

[BlissC]

Thanks! I can't believe I missed something so basic! (I guess that's what comes from trying to work far too late at night when you're starting to see double!)

 

[JLGWhiz]

Thanks! I can't believe I missed something so basic! (I guess that's what comes from trying to work far too late at night when you're starting to see double!)

I think we have all been there.
Regards, JLG