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
C1:D10 is the lookup table. Then
=LOOKUP(A3, C1:C10, D1:D10)

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


"AndyS" wrote:

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