=IF

[Nudie072]

Hi,

first time post.

I have to create a budget file from LY sales. I need to reference a % increase based on a catergroy. So (=if(the_cat,Percent_table=[cat],[LY_sales]*Percent_table[month]), but it only sees to refer to one catergory. i want it to be dynamic. I have the sumif calculating from LY_sales fine.

Can anyone help.

Sample attached.

 

[NARAYANK991]

Hi ,

I am not able to understand your requirement ; can you indicate how you want a formula to be dynamic , and even more basic , which formula , in which cells , are you referring to ?

Narayan

 

[Nudie072]

Hi ,

I am not able to understand your requirement ; can you indicate how you want a formula to be dynamic , and even more basic , which formula , in which cells , are you referring to ?

Narayan

Hi Narayan,

Thanks for you reply.

I need to put the formula in the column "April", refer to column "code". This is where it becomes dynamic as I have different categories listed in this column. I have a second table which has the % increase based on a category & month. I've been able to get the formula =if(percentage_table

=[code],[LY April]*percentage_Table[April],"N/A") to work, but only on one category, I get #VALUE error if I have more than one category in my percentage_table.

 

[NARAYANK991]

Hi ,

It is still not clear what is to be done.

1. Are you referring to the worksheet tab Budget_Master ?

2. The data in column B , whose header is CAT , consists of 21 distinct values.

3. The data in column C , whose header is Description , consists of 10 distinct values.

4. How many values should be output for the month April , 21 or 10 or some other value ?

If you can manually put down a few outputs which the formula should give , things will be clear.

Narayan