Help with and Excel If Then Formula

[David_McDaniel]

I need to create a Formula with multiple calculations. I need to look at one cell and if there is a value in it (not blank) then use that value. If there is no value there (blank) then get the MIN value from a range of cells).

The formula and results will go into cell C3

The IF is when D3 is not blank, use that value

If it is blank, then use the value from a MIN formula of =MIN(D3:R3)

Your help is greatly appreciated.

[#2 · Accepted solution]

@David_McDaniel 

Try this one:

=IF(ISBLANK(D3),MIN(D3:R3),D3)

[#3]

That worked perfectly. Thank you!

[#4]

You're welcome!