| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
switching between formula display and value
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
switching between formula display and value
The cell is probably text
Try selecting the cell Format|Cell|Number and select general Tap F2 and then enter Mike "layvanai" wrote: 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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
switching between formula display and value
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" wrote in message ... 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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
switching between formula display and value
Thanks Mike it worked, but I don't understand what F2 does.
Layvanai "Mike H" wrote: The cell is probably text Try selecting the cell Format|Cell|Number and select general Tap F2 and then enter Mike "layvanai" wrote: 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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
switching between formula display and value
F2 simply put you into edit cell mode
"layvanai" wrote: Thanks Mike it worked, but I don't understand what F2 does. Layvanai "Mike H" wrote: The cell is probably text Try selecting the cell Format|Cell|Number and select general Tap F2 and then enter Mike "layvanai" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| switching x axis | Charts and Charting in Excel | |||
| Switching Between Showing Formula Or Actual Result In A Cell ? | New Users to Excel | |||
| switching the worksheet? | Excel Discussion (Misc queries) | |||
| VBA Switching Between Macros | Excel Discussion (Misc queries) | |||
| Switching cells | Excel Discussion (Misc queries) | |||
Linear Mode
