=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