How to return zero/empty value in an IF-formula from a cell with only a formula (no result)?

[Jonathan155]

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!

[#2]

does your column I have a formula? could you share your sample data?

[#3]

@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

[#4 · Accepted solution]

@Jonathan155 

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.

[#5]

Thank you! Problem solved 🙂

[#6]

@Jonathan155 , you are welcome