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
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