MS EXCEL FORMULA HELP

Sneakee

Excel Formula Help

Set of Data
RESULT A

---

RESULT B

---

HIGH RESULT B OR AVERAGE A+B
23.16

---

23.42

---

23.42
23.54

---

23.1

---

23.32
22.96

---

23.1

---

23.1

I need help on the formula for the High Result B or Average A+B box.
Struggling for hours to make out a formula that will choose the High B result and average A and B if B is lower than A.
I only have a basic to moderate knowledge of Excel, appreciate any help on this.
CHEERS

FSL

You need to use a conditional function. See the Excel help on the if function.

If(logical test,Value if true,Value if false)

Thoie

=IF(B2>A2,B2,AVERAGE(A2:B2))

Stugots

or alternatively....
=MAX(B2;AVERAGE(A2:B2))

Sneakee

I used this, another add to it is how do I round up the averages to 2 decimal places.

if I get in the average
22.275, how do I get the formula to bring to 22.28 instead
I used this formula
=IF(B2>A2,B2,AVERAGE(A2:B2))


A2----22.77B2---22.6 Split I want

---

22.69What I get----22.685


Thanks for your help!

Sneakee

Format the column to decimal places....silly of me.
Thanks anyway!

Stugots

Or....

=ROUND(MAX(B2;AVERAGE(A2:B2));2)