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.
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.
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
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
Thank you in advance for your help,
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?