excel 2010 formula Help

Sixshooter

Estimable
Oct 26, 2014
1
0
4,510
0
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
27
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.
 
Thread starter Similar threads Forum Replies Date
S Apps General Discussion 5
H Apps General Discussion 13
U Apps General Discussion 1
P Apps General Discussion 1
P Apps General Discussion 4
D Apps General Discussion 2
W Apps General Discussion 2
C Apps General Discussion 7
B Apps General Discussion 4
M Apps General Discussion 11
indyitguy Apps General Discussion 8
wanamingo Apps General Discussion 1
E Apps General Discussion 1
GOM3RPLY3R Apps General Discussion 6
Christopher Chung Apps General Discussion 4
S Apps General Discussion 4
G Apps General Discussion 1
E Apps General Discussion 3
A Apps General Discussion 1
R Apps General Discussion 2

ASK THE COMMUNITY