Forum Discussion

Brandon Ness's avatar
Brandon Ness
Copper Contributor
Apr 06, 2018
Solved

LF Assistance on formula

I have tried several different ways to do this, but starting with a clean slate and asking everyone for assistance. Here goes. 

 

Formula 1: 

=IFS(F6<1,0,F6<25, "24P",F6<49,"48P")

This cell determines what the value is....24P or a 48P 

 

Formula 2:

=IFS(L6<1, 0, L6<277, 1, L6>276, 2)

This cell determines whether there is a quantity of 0, 1 or 2 (but just for the 24P)

 

Formula 3: 

=IFS(L6<1, 0, L6<544, 1, L6>543, 2)

This cell determines whether there is a quantity of 0, 1 or 2 (but just for the 48P)

 

I need to be able to combine or create a new formula that specifies when Cell with Formula 1 stays "24P" then it uses Formula 2 for calculating a quantity. If Formula 1 changes to "48P" then Formula 3 is used for calculating quantity. 

 

What do you think? 

Formulas & Functions
Requests
  • Haytham Amairah's avatar
    Haytham Amairah
    Apr 06, 2018

    Hi Brandon,

     

    You can combine them in this formula, with supposing that the formula that returns either 24P or 48P is in cell F2.

     

    =IF(F2="24P",
 IFS(L6<1, 0, L6<277, 1, L6>276, 2),
 IF(F2="48P",
 IFS(L6<1, 0, L6<544, 1, L6>543, 2),""))

     

     

     

    Regards

2 Replies

  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    Apr 06, 2018

    Hi Brandon,

     

    You can combine them in this formula, with supposing that the formula that returns either 24P or 48P is in cell F2.

     

    =IF(F2="24P",
 IFS(L6<1, 0, L6<277, 1, L6>276, 2),
 IF(F2="48P",
 IFS(L6<1, 0, L6<544, 1, L6>543, 2),""))

     

     

     

    Regards

    • Brandon Ness's avatar
      Brandon Ness
      Copper Contributor
      Apr 06, 2018
      Amazing! somehow I feel like I should have thought of that, but this works perfectly! Thank you so very much for your help!