Formula
 

Can someone give me a formula for this scenario? If the Sum of A1 and A2
equals a 1, the result would give me a $15 answer. If that same sum equals a
2, then the result would give me a $25 answer

Formula
 

Try:

=IF(SUM(A1:A2)=1,15,IF(SUM(A1:A2)=2,25,"Not 1 or 2"))

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"pepsiguy" wrote in message
...
Can someone give me a formula for this scenario? If the Sum of A1 and A2
equals a 1, the result would give me a $15 answer. If that same sum
equals a
2, then the result would give me a $25 answer

Formula
 

=if(a1+a2=1,15,if(a1+a2=2,25,"not 1 or 2"))



pepsiguy wrote:

Can someone give me a formula for this scenario? If the Sum of A1 and A2
equals a 1, the result would give me a $15 answer. If that same sum equals a
2, then the result would give me a $25 answer

--

Dave Peterson