switching between formula display and value

[layvanai]

The formula written as =IF('Boiler 3'!$M$15<>"",'Boiler 3'!$M$15,"") does not
display the result in the cell even after switching the sheet between formula
and value (ctrl `). This same formula works in other areas of the same
worksheet.

 

[Mike H]

The cell is probably text
Try selecting the cell
Format|Cell|Number and select general
Tap F2 and then enter

Mike

 

[Bob Phillips]

Perhaps the cell is formatted as text. Change the format to General, and
F2-Enter and see if that cures it.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[layvanai]

Thanks Mike it worked, but I don't understand what F2 does.

Layvanai

 

[Mike H]

F2 simply put you into edit cell mode

Thanks Mike it worked, but I don't understand what F2 does.

Layvanai