switching between formula display and value

  • Thread starter Thread starter layvanai
  • Start date Start date
L

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.
 
The cell is probably text
Try selecting the cell
Format|Cell|Number and select general
Tap F2 and then enter

Mike
 
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)
 
Back
Top