Cell F12 continues to return #N/A when no value is within D12.

[Mrniceguyy]

F12 returns #N/A when I should have the value of C12/E12 if D12 is has no value you. Am I missing a function?
When D12 is selected, It should add 10% to F12.

 

[Fluff]

The vlookup will return #N/A when it fails to find the lookup value (D12) in the lookup range (Data!A31:A32). You can use the IFNA function to handle that.

 

[kweaver]

Try this:

=IF(AND(E12>=1,D12=""),C12/E12,B12*0.01+C12/E12)

 

[Mrniceguyy]

The vlookup will return #N/A when it fails to find the lookup value (D12) in the lookup range (Data!A31:A32). You can use the IFNA function to handle that.

But how do I return the value of C12/ E12 in F12

 

[Fluff]

How about

=IF(E12>=1,C12/E12+IFNA(VLOOKUP(D12,Data!A31:B32,2,0),0),"")