# excel 2010 formula Help

#### Sixshooter

##### Estimable
I need a formula to solve the following.
It involves 3 cell's, I will say A1,A2,A3
I need to total only A2 into A3 if the value in A1 is less than 1. But if the value in either A1 or A2 is 1 or greater the total values of both A1 & A2 are added together and placed in A3

#### mesab66

##### Distinguished
Does the OP realise that it is possible for both conditions to be true at the same time!

and...1st post by OP -> OP is almost certainly trolling

#### thx1138v2

##### Distinguished
Put this formula in A3:
=IF(A1<1,A2,IF(OR(A1>1,A2>1),A1+A2,0))

Your explanation did not say how to handle the situation where A1=1. The IF statement places a zero in A3 if A1=1. Change as you desire.

#### mesab66

##### Distinguished
edit...delete

Apps General Discussion 5
Apps General Discussion 13
Apps General Discussion 1
Apps General Discussion 1
Apps General Discussion 4
Apps General Discussion 2
Apps General Discussion 2
Apps General Discussion 7
Apps General Discussion 4
Apps General Discussion 11
Apps General Discussion 8
Apps General Discussion 1
Apps General Discussion 1
Apps General Discussion 6
Apps General Discussion 4
Apps General Discussion 4
Apps General Discussion 1
Apps General Discussion 3
Apps General Discussion 1
Apps General Discussion 2