How to use multiple IF's

[monskaye]

Not sure how to use the "if" command in multiple scenarios (if it even exist like countifs)


In my table there are 2 results, there are criteria in which one scenario will have remarks of "passed"

1) each of result shall not be below 90% of the base
2) average should be at least equal to the value of the base

so if it cannot meet the requirements it will have remarks of "failed"

a sample of each scenario is shown in sample workbook.

hoping for help.. Thanks a lot!

[AliGW]

Try this:

=IF(AND(AVERAGE($C$6:$C$7)>=C5,COUNTIF($C$6:$C$7,">="&C5*0.9)),"PASSED","FAILED")

[samba_ravi]

C10=IF(OR(COUNTIF(C6:C7,"<"&C5*0.9),C8<C5),"FAILED","PASSED")
Try this

[FlameRetired]

Withdrawn by FR.

[FlameRetired]

Interpreted differently and rearranged 'Remarks'.

If you offset 'Remarks' data can be "future proofed".

Please Login or Register  to view this content.

A

B

C

D

E

F

G

H

I

J

K

L

M

1

2

3

scenario 1

scenario 2

scenario 3

scenario 4

4

5

base

3000

base

3000

base

3000

base

3000

6

result 1

3220

result 1

4500

result 1

3300

result 1

2600

7

result 2

3000

result 2

2600

result 2

2700

result 2

2700

8

average

3110

average

3550

average

3000

average

2650

9

10

remarks

Passed

remarks

Failed

remarks

Passed

remarks

Failed

[monskaye]

Formula by Aligw did not work for scenario 4 , nflsales & fr worked on all scenarios

thank you very much!!!

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[monskaye]

Mind guys if I ask additional help/question??

What if there is just 1 result for 1 Scenario? but it will still read as 2 results and the average will be equal to the result.. Pls refer scenario 5 6 7

I was thinking of adding a new cell and hide it and put some formula in the hidden cell like :
IF(value of Result 2 = n/a , then average= Result 1)
Am confused how to construct it..

Thanks a lott

Ps. got it already thanks!