# Determine the lowest number but not if it is a blank

#### tomdig50

##### New Member
I have a spreadsheet that has the below fields

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)

### Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.
Try this:

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

Awesome!!! thanks worked perfectly!

You're welcome!

Replies
0
Views
389
Replies
5
Views
171
Replies
0
Views
258
Replies
1
Views
501
Replies
7
Views
435

1,196,308
Messages
6,014,572
Members
441,828
Latest member
cofracr

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back