Excel problem, Help!?
X, Y and Z are allocated cells
In cell A2 i need to put a formula that -
"If X is less than Y, enter Y and go to A8 (so values of cells A3,A4,A5 are null) , otherwise enter the lesser of Y or Z"
prof said something about null string and using "" and boolean experssions but i cant seem to figure it out.
Thanks in advance!
Answers & Comments
Verified answer
If X, Y, and Z are cells it would be important to know their addresses. That said, here is an attempt to clarify the salient points of your question:
The basic boolean expression is:
=IF(<condition>, <valueiftrue>, <valueiffalse>)
I will assume that X is cell X1, Y is cell Y1, and Z is cell Z1 (They could also be constants, but you that is an easy fix).
In Excel if X1 is less then Y1 then return Y1 else return A8 translates into this formula:
=IF(X1<Y1, Y1, A8)
To test if cells are null (empty) you can use:
=IF(AND(A3="", A4="", 15=""), "All Empty", "Not")
To enter the lesser of two values:
=IF(X1<Y1, X1, Y1)
Alternately:
=MIN(X1, Y1)
Hopefully there is enough information here that you can apply it to your notes and create the response your professor is looking for. If you still can't figure it out, most professors are very happy to answer questions from students.
Hope that helps...