Determine the lowest number but not if it is a blank

[tomdig50]

I have a spreadsheet that has the below fields

[/URL]upload pic[/IMG]

I need a formula that if one or the other field is blank then to use the field that is not blank as well if both are blank then the word DELETE should show up the only formula I have currently determines which price is lower which is =IF(E2<g2,e2,g2)
any help is appreciated!</g2,e2,g2)

 

[AliGW]

Try this:

=IF(AND(E2="",G2=""),"DELETE",MIN(E2,G2))

 

[tomdig50]

Awesome!!! thanks worked perfectly!

 

[AliGW]

You're welcome!