Hi,

I am just starting to try and do some basic formulas in Excel and thought I was doing well until I came up against a "forumula too long" error.

I am trying to get the cell G4 to display a sales number based on information provided from user input on a different worksheet. However, the information required is two fold; (1) the amount of clients (worksheet 2, cell f12) and (2)their consumption level (worksheet 2, cellf14).

Now if the user selects; "0-49" (amount of clients) and "modest" (consumption level) I want cell G4 on worksheet 1 to calculate the sales figure ((worksheet3,c14)*25.

Alternatively if the user selects; "0-49" (amount of clients) and "heavy" (consumption level) I want cell G4 on worksheet 1 to calculate the sales figure ((worksheet3,c14*3)*25

Their are 7 variables for amount of clients and 4 variables for consumption level.

I have been using IF((AND statements but agains get stuck as it is too long. Is there a more efficient way to do this?

I could really use some help here as I am now pretty lost.

Thanks so much for your help!!

Mebs

I am just starting to try and do some basic formulas in Excel and thought I was doing well until I came up against a "forumula too long" error.

I am trying to get the cell G4 to display a sales number based on information provided from user input on a different worksheet. However, the information required is two fold; (1) the amount of clients (worksheet 2, cell f12) and (2)their consumption level (worksheet 2, cellf14).

Now if the user selects; "0-49" (amount of clients) and "modest" (consumption level) I want cell G4 on worksheet 1 to calculate the sales figure ((worksheet3,c14)*25.

Alternatively if the user selects; "0-49" (amount of clients) and "heavy" (consumption level) I want cell G4 on worksheet 1 to calculate the sales figure ((worksheet3,c14*3)*25

Their are 7 variables for amount of clients and 4 variables for consumption level.

I have been using IF((AND statements but agains get stuck as it is too long. Is there a more efficient way to do this?

I could really use some help here as I am now pretty lost.

Thanks so much for your help!!

Mebs

## Comment