If
Cell A1 has a value of 130
Cell A2 has a value of 150
how do I write a formula to put the lowest value in cell A3?
=A1 if Cell value is lower than A2, if not A3? I'm stumped.
Thanks!!
If
Cell A1 has a value of 130
Cell A2 has a value of 150
how do I write a formula to put the lowest value in cell A3?
=A1 if Cell value is lower than A2, if not A3? I'm stumped.
Thanks!!
hi there laforce. do you mean:
=A1 if Cell value is lower than A2, if not A2
if you want the result in A3, you cannot refer to A3 itself
maybe:
=MIN(A1:A2)
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
laforce,
The formula in cell A3:
=MIN(A1:A2)
Have a great day,
Stan
Windows 10, Excel 2007, on a PC.
If you are satisfied with the solution(s) provided, please mark your thread as Solved by clicking EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
Thanks Guys!!!
laforce,
You are very welcome. Glad we could help.
And, come back anytime.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks