Multiple formulas in one cell...

Hi. Hope that someone will be able to help with my problem...

I am trying to add a multiple formula into one cell which presents different values based on other cell values and information.

Heres the scenario:-

Main workbook:

(H5) a value will be entered manually between 0-90,000
(H9) ive created a drop down list which 4 different values, Label 1, Label 2, Label 3 and Label 4
(H24) This is the cell where I want the mutiple formula to calculate a value based on the info in H5 and H9.

Ive used data validation on a 2nd sheet (named Sheet 1) using cells:-

(A15) 9999
(A16) 10000

My aim is so that If value in H9 is Label 1 then H24 = 595. No problem there.
If value in H9 is Label 2 and H5 is <=9999 then H24 = 295. If H5 is >=10000 then H24 = 395. This is to continued if H9 is Label 3 and Label 4, still need the value to 295 or 395 depending on value in H5.

Ive managed to get this working formula ok so far:-

=IF(H9=Sheet1!A9,595,+IF(H9=Sheet1!A10,395,+IF(H9=Sheet1!A11,395,+IF(H9=Sheet1!A12,395))))

But I cannot include the extra variable anywhere and get the formula to work correctly.

I have created a separate formula using a dummy cell to show the values required if Label 2,3 and 4 are chosen <=9999 and >=10000:-

=IF(H5<=Sheet1!A15,295,395)

I cannot seem to link the 2 formulas together in the same cell.

Can anyone help??

Many thanks in advance

Please Login or Register  to view this content.

If the results are the same for Label 2, Label 3, and Label 4, there's no need to have your formula do anything with them other than determine whether that cell is Label 1. (I suppose you could have a condition for it being blank, but this wasn't part of your original post.)

Darkyam

Thank you for pointing out this simple solution. All seems so logical now...

I appreciate your swift response.

Regards