Fred Smith wrote:
Whether a cell has a number or is the result of a formula is immaterial. It
looks the same to Excel. Also, showing us what you tried will always result
in better advice, as we have a better idea of what you are trying to do.

As a guess, see if this helps:
=if(or(a1=1,a1=2,a1=3,a1=4),a2,"none of the values found")

Regards,
Fred.

Hi!

[quoted text clipped - 6 lines]

Any suggestions or tips would be appreciated. Thanks!


Here's the formula:

=IF(E22=0,0):IF(E22=1,$G$9):IF(E22=2,$G$10):IF(E22 =3,$G$11)

Where e22 is the number 0, 1, 2, or 3.
So if a 0 is in e22, put in 0
If a 1 is in e22, put in the number from cell G9
If a 2 is in e22, put in the number from cell g10
If a 3 is in e22, put in the number from cell g11

Cells G9, G10 and G11 were originally the sum of another cell, that was
calculated with a formula. I changed this to paste the value of the formula
instead of the sum, but it didn't seem to help.

Thanks for your assistance!