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 va...
excel
Formulas and Functions
Patrick2788's avatar
Patrick2788
Silver Contributor
Nov 03, 2023

David_McDaniel 

Try this one:

=IF(ISBLANK(D3),MIN(D3:R3),D3)
  • David_McDaniel's avatar
    David_McDaniel
    Copper Contributor
    Nov 03, 2023
    That worked perfectly. Thank you!
    • Patrick2788's avatar
      Patrick2788
      Silver Contributor
      Nov 03, 2023
      You're welcome!

Resources