Adding 1 of 2 numbers to a cell to get a specific number

[pleasesmile]

Hi,

I need to take a number that is in one cell (that can change) and add either 5 or 7 to it to get one of the following totals - 38 / 42 / 48 / 54.

I attached the spreadsheet for reference.

Thank you,

[judgeh59]

what if you enter a number in Body that won't equal any of those totals by adding 5 or 7....such 34...what should happen?....what should happen if it does?

[Teethless mama]

=SUMPRODUCT(({38,42,48,54}-{5;7}=A10)*{38,42,48,54})

You will get '0' value if the values don't match either add 5 or 7 to the BODY

[pleasesmile]

Perfect! Thank you

[Teethless mama]

You're Welcome!