# Solved Value Calculation based on values in other cells

August 2, 2012 at 03:45:49
Specs: Windows XP
 If I have an EXCEL which has:Column A mentioning illumination status as FL or BL or NLColumn B has sq ft areaI want that Column C should automatically give the value as mentioned below:If A=FL, then value in C should be B multiply by 10If A=BL, then value in C should be B multiply by 25If A=NL, then value in C should be B multiply by 10

See More: Value Calculation based on values in other cells

#1
August 2, 2012 at 04:43:09
 Here is a formula:=IF(A1="FL",B1*10,IF(A1="BL",B1*25,IF(A1="NL",B1*10)))if A1 = FL it will multiply value in C by 10if A1 = BL it will multiply value in C by 25if A1 = NL it will multiply value in C by 10

Report •

#2
August 2, 2012 at 09:35:06
✔ Best Answer
 Assuming that A1 will always contain one of the three values mentioned, the formula can be shortened to:=IF(OR(A1="FL",A1="NL"),B1*10,B1*25)Since FL and NL both result in B1*10, you can OR those conditions instead of checking for them individually.Since there are only 3 choices to choose from (assumed) then if A1 is not FL or NL, it must be BL. Therefore there is no need to actually check for BL with an IF function.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

#3
August 2, 2012 at 21:32:43
 Thanks, it exactly did what I wanted

Report •

Related Solutions