Excel question - If cell equals a specific value (1-4), then target cell equals a specific value.?

Question

Excel question - If cell equals a specific value (1-4), then target cell equals a specific value.

Example

If L42 =1 then K43 = 628,
if L42=2 then K43=772,
if L42=3 then K43=1024,
if l42=4 then k43 = 1174

Answer 1

K43 =CHOOSE(L42,628,772,1024,1174)

Answer 2

This Site Might Help You.



RE:

Excel question - If cell equals a specific value (1-4), then target cell equals a specific value.?

Excel question - If cell equals a specific value (1-4), then target cell equals a specific value.



Example



If L42 =1 then K43 = 628,

if L42=2 then K43=772,

if L42=3 then K43=1024,

if l42=4 then k43 = 1174

Answer 3

I'm an Excel power user and I do not understand what you are trying to accomplish, however, I can give you a formula that will not give you an error if a value is null (blank): =if(B1="",0,C1) this is an example of a conditional formula - what it says is: if cell B1 is blank then the value of this formula is zero, otherwise if B1 is anything else than zero the value is equal to cell C1 =(condition, what to do if condition true, what to do if condition false) - If you give me a few rows of data I may be able to help you further. FYI when you type those quotes into the formula make sure there are not any spaces between them. you can use the formula I just gave you except use the correct cell references =if(G3="",0,G3) this will give you a zero if g3 is blank, when you copy it down the g3 should change to g4 the next row down. This will fix your problem but I think you are just not copying your formula correctly.