Nested formulas - formula displays instead of value

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.
 
T

Trevor Shuttleworth

Check Tools | Options... | View tab | Window Options | Uncheck Formulas

Regards

Trevor
 
G

Gord Dibben

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
 
F

Frank Kabel

Hi Leonlin
the cell may be formatted as 'Text'. Goto 'Format - Cells' and change
the format to 'General'. Reenter your formula
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top