multiple answers

[Guest]

In need to us something similar to IF function but to have multiple answers ie
if A3=5 then A5=$9
If A3=6 then A5=$12
IF A3=55 Then A5=$30
Any help would be greatly appreciated

 

[Guest]

You could use a lookup. As long as the lookup vector is in ascending order
(ie 5,6,55) in A5, enter
=LOOKUP(A3,{5,6,55},{9,12,30})

If you have more numbers to add, you might set up a lookup table. Let's say
C110 is the lookup table. Then
=LOOKUP(A3, C1:C10, D110)

If the lookup vector (or key) isn't in ascending order, look at VLOOKUP.

 

[Bob Phillips]

Simple If

=IF(A3=5,9,IF(A3=6,12,IF(A3=55,30,"")))

in A5 and format as $ amount.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Leo Heuser]

In need to us something similar to IF function but to have multiple
answers ie
if A3=5 then A5=$9
If A3=6 then A5=$12
IF A3=55 Then A5=$30
Any help would be greatly appreciated

Andy

One more way:

=INDEX({9,12,30},MATCH(A3,{5,6,55},0))