Thread
:
Formula
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Sandy Mann
external usenet poster
Posts: 2,345
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
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann