whatif

PRODUCT. SALES. CONTRIBUTION A. $250. 25% B $350. 35% C. $100 10% D. $300 30% I am trying to build a simple tool to update contribution % based on user input (new sales volume) for a...

Hello, I'm trying to do an IF statement formula but I have too many arguments. My goal is to assign a numeric value in cell C3 based on conditions met or not met in C2 and C1. For example, as shown if table below --- if income is between $24,600 - $49,200 and the family size is 4 or fewer...

Default Re: Vlookup Sheet 1 Column A - Price Column B - Product name Sheet 1 is the lookup sheet in cell C3 - I want to bring back if column B matches column A on sheet 2 and if the number in column a in sheet 1 falls between two numbers in sheet 2 Theae are column C and D with c being the...

Hi everyone, Apologies if this has been answered before. I am creating a rebate calculator for my business. Some people get rebates based on every order (TYPE1) (i.e. £0.1), others get volume based rebates (TYPE@) across the year, i.e. if they order 1000 items they get £0.1, 2000 items £0.02...

I'm after some help on quite a complex formula I think... I have a spready that in worksheet 1 states all reciepts with in column A the account name, column F the sum of payment, column G the month paid. In the additional worksheets I have the totals for each month by account name i.e...