excel 2010 formula Help

Sixshooter

Estimable
Oct 26, 2014
1
0
4,510
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
 

thx1138v2

Distinguished
Jun 18, 2011
74
1
18,610
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.