LinkBack URL
About LinkBacks
for example, what does the test A15=B16=C18 in =IF(A15=B16=C18,"X","Y") mean and what does it do?
for example, what does the test A15=B16=C18 in =IF(A15=B16=C18,"X","Y") mean and what does it do?
I suggest you use the Formula Evaluation Tool and watch Excel Calculate it one step at a time.
On the Formulas Tab, click Evaluate Formula.
this relates to my question so I didn't make it a new thread
I use the ‘’min’’ function to determine the smallest of three numbers.
is there a way to determine the position of the resulting minimum value
in the min function string of three numbers?
Try
=MATCH(MIN(A1:C1),A1:C1,0)
Originally Posted by Joe Miller
I would guess it was written to perform IF(AND(A15=B16,b16=C18),"X","Y")
But =X=X=X=X formulas don't work like that
You should hit F5, because chances are I've edited this post at least 5 times.
Example of Array Formulas
Click the * below on any post that helped you.
that worked great. tried to give you another ''add reputation'' but they wouldn't let me.
I'll do it for you (although you may have more rep power than I do)!
Last edited by Tony Valko; 08-04-2014 at 08:38 PM.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
thanks tony. jonmo1 is a great resource for me, so should be smoozed regularly.
I'm from Pittsburgh. born [1931] and raised there.
peace
Glad to help, thanks for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks