Forum Discussion
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 d...
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
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
Amazing! somehow I feel like I should have thought of that, but this works perfectly! Thank you so very much for your help!