Range of Name in Formula

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

Guest

I want to make the following formula =IF('type',"cd",total_value*total_percentage,") and here are the component
'type' is a name applied to a range of cells that can contain variable text (in the for instance I am looking for "cd").

I only want the value returned of total_value*total_percentage if the 'type' is equal to "cd"
So how do I define the name to contain the variable 'text' info? and how do I make the IF function give me a return value only when my 'type' is as defined

any takers?
 
=IF(type="cd",total_value*total_percentage,"")

But this will only work with "TYPE" and the other two ranges being single
cell ranges......if you're wanting to do this formula to three columns of
data (where column A is the "TYPE" and comluln B is the "total_value" and
column C is the "total_percentage"....) you could use........

=IF(A1="CD",B1*C1,"")
and copy it down column D.......


Vaya con Dios,
Chuck, CABGx3


thd said:
I want to make the following formula
Click to expand...
=IF('type',"cd",total_value*total_percentage,") and here are the components
'type' is a name applied to a range of cells that can contain variable
Click to expand...
text (in the for instance I am looking for "cd").
I only want the value returned of total_value*total_percentage if the 'type' is equal to "cd"
So how do I define the name to contain the variable 'text' info? and how
Click to expand...
do I make the IF function give me a return value only when my 'type' is as
defined?
 
Back
Top