Forum Discussion

David_McDaniel's avatar
David_McDaniel
Copper Contributor
Nov 03, 2023
Solved

Help with and Excel If Then Formula

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.

Resources