Thread: Formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sandy Mann Sandy Mann is offline
external usenet poster
 
Posts: 2,345
Default 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