Forum Discussion
Solved
Formulas in a certain worksheet seem not to work.
Normally I do not have problems with formulas in worksheets. But now I can not find out why a simple IF formula does not work properly. If I run this formula in a new worksheet, no problem, works fin...
Cells A4, A5 etc. contain two spaces. A space is a text value, and Excel treats all text values as greater than all numbers, in particular as >0. So A4>0 is TRUE.
Workaround 1:
- Select column A.
- Press Ctrl+H to activate the Replace dialog.
- Enter two spaces in the 'Find what' box and leave the 'Replace with' box empty.
- Click 'Options >>'.
- Tick the check box 'Match entire cell contents'.
- Click 'Replace All'
Workaround 2:
- Leave column A as it is.
- Change the formula in B3 to
=IF(A3<>" ",A3,B2)- Fill down.
Both should result in the formulas returning the desired result.
Huib Bruijstens: I am new here and see, that the attached file does not show the formula.
Here it is =IF(A2>0;A2;B1)