Forum Discussion
How to return zero/empty value in an IF-formula from a cell with only a formula (no result)?
I would like the marked cell to come up empty when copying the formula to empty rows... what is wrong with the formula?
All help is appreciated!
Since formula in column I returns empty string if nothing is found, you need to compare with empty string as well. In English notation
=IF( I15="", "", IF(I15>=7, "JA", "NEI" ) )That works for blank cells as well.
- does your column I have a formula? could you share your sample data?
Rodrigo_ Yes, column I has this formula; =HVISFEIL(INDEKS($V$8:$AA$19;SAMMENLIGNE(G15;$U$8:$U$19;0);SAMMENLIGNE(H15;$V$7:$AA$7;0));""). Returning a number between 0 and 12 based on the dropdown data selection lists in columns G and H.
How do I solve the issue mentioned in my originial post; e.g. when column I is empty (no data chosen in column G or H)?
Tried to share my file but I was not supported in this message
Since formula in column I returns empty string if nothing is found, you need to compare with empty string as well. In English notation
=IF( I15="", "", IF(I15>=7, "JA", "NEI" ) )That works for blank cells as well.
