An IF formatting problem?

[Ziggy_ks1]

Hiyas folks:
I am working on what I thought would be a simple sheet to calculate the amount of time needed to shut off my line for a product change. The Problem is I haven't figured out how to put in the cell to show the number I want via another number. I want 0 to equal 126, 1 to equal 124, 2 to equal 122 etc.
Thanks for any help in advance.
Mark

[VBA Noob]

Maybe

=IF(A1="","",LOOKUP(A1,{0,1,2,3,4,5,6},{126,124,122,120,118,116}))

VBA Noob

[Ziggy_ks1]

I'll Give that a shot thanks.

[Mark@Work]

If your initial numbers are simple integer values between 0 and 6 then you could use:
=CHOOSE(A1+1,126,124,12 2,120,118,116)

rather than the lookup array function.

Mark.

[ChemistB]

Or, you could use a simple linear formula (y=mx+b) where m = -2, b=126
Assuming your x (0 to 6) is in cell A1

=A1*-2+126

ChemistB