Forum Discussion
David_McDaniel
Nov 03, 2023Copper Contributor
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.
3 Replies
- Patrick2788Silver Contributor
- David_McDanielCopper ContributorThat worked perfectly. Thank you!
- Patrick2788Silver ContributorYou're welcome!