IF and OR function combination

**Mofa** · 03-20-2009, 07:25 AM

I need help on the following problem:

I have 2 cells with numbers.
In a 3rd cell I want to create a formula which looks at the 2 data cells and shows a value. The rules are the following:
If C1 or C2 are bigger than Xthen C3=value1 else C3=value2
I have some basic excel knowledge but im not very familiar with functions, so please help me out on this one.
I'm using Excel 2007.

Thanks in advance!

**zbor** · 03-20-2009, 07:26 AM

=if(or(c1>3;c2>3);100;200)

**kroz** · 03-20-2009, 07:27 AM

Please Login or Register  to view this content.

**daddylonglegs** · 03-20-2009, 07:28 AM

Do both need to be greater or just 1? Try a formula like this for C3

=IF(COUNTIF(C1:C2,">10")=2,8,88)

If you need both to be greater. For only 1 change =2 to =1 and change other values as required