If Function?!?

C

ChrisMattock

I have 4 different statements of which one needs to be entered into a
cell depending on some conditions, I have worked out the conditions to
produce a true/false response in four cells as seen below

A B
1 FALSE STATEMENT 1
2 FALSE STATEMENT 2
3 FALSE STATEMENT 3
4 TRUE STATEMENT 4

Depending on which cell is true I want the result cell to have a
different statement come up, i.e. If A4 is TRUE then STATEMENT 4 should
be shown in cell B10, if A3 is TRUE then STATEMENT 3 should be shown in
cell B10... the conditions are such that there is only ever one cell
that can be TRUE.

Someone help please :D
 
L

Leo Heuser

"ChrisMattock" <[email protected]>
skrev i en meddelelse
I have 4 different statements of which one needs to be entered into a
cell depending on some conditions, I have worked out the conditions to
produce a true/false response in four cells as seen below

A B
1 FALSE STATEMENT 1
2 FALSE STATEMENT 2
3 FALSE STATEMENT 3
4 TRUE STATEMENT 4

Depending on which cell is true I want the result cell to have a
different statement come up, i.e. If A4 is TRUE then STATEMENT 4 should
be shown in cell B10, if A3 is TRUE then STATEMENT 3 should be shown in
cell B10... the conditions are such that there is only ever one cell
that can be TRUE.

Someone help please :D
Click to expand...


Hi Chris

One way:

In B10

=INDEX(B1:B4,MATCH(TRUE,A1:A4,0))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with logical function 3
IF OR AND in same conditional formula 2
Logical formatting for multiple values 1
Testing for conditions with IF statement and AND function 1
Help with complex "IF" formula !!! 2
if statement true=now false retains last true 3
MATCH not working in IF statement 6
Conditional Format - using 3 different cells conditions together 4

Top