Formula

[Guest]

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

 

[Sandy Mann]

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

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

 

[Sandy Mann]

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

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

 

[Dave Peterson]

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

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]

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

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