• ## using 2 multi conditional if then statements based on value of another cell

Re: using 2 multi conditional if then statements based on value of another cell

I apologize, I did not know the forums were linked together, as this is my first day posting in these types of forums.

• ## using 2 multi conditional if then statements based on value of another cell

Re: using 2 multi conditional if then statements based on value of another cell

had to change a few cells around, but yes that did work, and I believe I understand the concept of why it was not working and why your formula does work.

Thank you AliGW

• ## using 2 multi conditional if then statements based on value of another cell

Re: using 2 multi conditional if then statements based on value of another cell

I have tried that formula as well. It returns a value of "false" when n3=-1 and criteria are not met. I need it to return 0 so all of my other formulas in the sheet will calculate correctly

• ## using 2 multi conditional if then statements based on value of another cell

I have searched thru the treads and tho there are a few threads related to multiple if then statements in one cell nothing seemed relavent or worked.

I have a value of either 1 or -1 in column N

I need to use formulas

if(n3=-1,IF(Q3<D4,O3-D4,IF(P3>E4,N3-E4,0)
if(N3=1,IF(Q3>E4,Q3-N3,IF(P3<D4,D4-N3,0)

I have tried using OR between the two formulas but always get 0 returned,
the formulas both work independently.

Is there a function I am not aware of, or am I using the Or function wrong?