Forum Discussion
How to return zero/empty value in an IF-formula from a cell with only a formula (no result)?
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.
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.
- Thank you! Problem solved 🙂
Jonathan155 , you are welcome
