Return a value based on different conditions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Cell A1 has the text "QUAD". Cell B1 = 8. Is there a way to tell cell C1 to return B1*a given value based on the text in A1 and also tell C1 to return B1*a different value if A1 has a different text name in it. I am thinking about the "IF" and "OR" functions but I can't seem to make it work. Any help is greatly appreciated.

Ron
 
Hi Ron
try the following in C1:
=IF(A1="QUAD",B1*value1,IF(A1="Other text",B1*other value,"do
nothing"))

HTH
Frank
 
Ron,

This is how using IF

=IF(A1="QUAD",B1*1,IF(A1="DOUBLE",B1*2,B1*3))

but you are limited tgo 7 tests.

If the multiplier is 1,2,3,4, etc, you could use

=B1*MATCH(A1,{"QUAD","DOUBLE","Alpha"},0)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Ron F said:
Cell A1 has the text "QUAD". Cell B1 = 8. Is there a way to tell cell C1
Click to expand...
to return B1*a given value based on the text in A1 and also tell C1 to
return B1*a different value if A1 has a different text name in it. I am
thinking about the "IF" and "OR" functions but I can't seem to make it work.
Any help is greatly appreciated.
 
Back
Top