Nested formulas - formula displays instead of value

  • Thread starter Thread starter Leolin
  • Start date Start date
L

Leolin

Hi,

I am having trouble with this nested forumula. It works -
I know it does but the cell keeps displaying the formula
instead of the value(result).

Ie below:

=IF(I4="","",IF(I4="CAP",VLOOKUP(S4,'IMAC Indicative
Times V05'!A:C,3,FALSE),VLOOKUP(S4,'IMAC Indicative Times
V05'!A:H,8,FALSE)))

Does anyone know how get it to show the answer.
 
Check Tools | Options... | View tab | Window Options | Uncheck Formulas

Regards

Trevor
 
Leolin

If it is just the one formula, perhaps the cell was pre-formatted as Text.

Change to General format then hit F2 then <ENTER>

Gord Dibben Excel MVP
 
Hi Leonlin
the cell may be formatted as 'Text'. Goto 'Format - Cells' and change
the format to 'General'. Reenter your formula
 
Back
Top