How do I for create Multiple Conditional Formulas in a single cell?
For example:
=IF(B5<0,IF(K5="Short",(L5-M5)*10000,(M5-L5)*10000),"") is one of the
equations, but I need it to multiply by 100 instead of 10000 if the answer is
greater than 1000.
I could also have it so it multiplies the different equation if word
criteria in a different cell from the same row is different. I dont know how
to do that either.