ExcelBanter - Weird "If" result

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Weird "If" result (https://www.excelbanter.com/excel-discussion-misc-queries/257783-weird-if-result.html)

Brad

Weird "If" result

No lie --- using formula evalutator

=if(false,#na,"Expanding5")
hit enterand the following shows up
"Expanding4"

The only differerence is the 4 rather than the correct 5 - Don't get it

any ideas??

Brad

Weird "If" result

Workbook calculations set to manual - never mind
--
Wag more, bark less

"Brad" wrote:

No lie --- using formula evalutator

=if(false,#na,"Expanding5")
hit enterand the following shows up
"Expanding4"

The only differerence is the 4 rather than the correct 5 - Don't get it

any ideas??

All times are GMT +1. The time now is 05:27 PM.