need some help with an IFS statement

[Tazzbjs]

Currently I have an IF statement with a vlookup

=IF(G6="","",VLOOKUP($G6,'Safety Point Lang'!$A$6:$B$41,2,FALSE))

. I want to expand on this so that when cell O6 (expiration date) reaches 0 or less the value returned is 0. Any assistance is greatly appreciated.

 

[VoG]

Try

=IF(O6<=0,0,IF(G6="","",VLOOKUP($G6,'Safety Point Lang'!$A$6:$B$41,2,FALSE)))

 

[Tazzbjs]

Great, That worked perfectly.