Forum Discussion
Solved
How Do I Calculate Different Cells Using Different Formulas?
I have multiple cells that require different calculations within the formula (I should also point out, that one the cells (Q5) is SOMETIMES a negative number and other times it's positive). Below is ...
Try this:
=(N5+Q5*(Q5<0))*C5+B6The part (Q5<0) return TRUE (or 1) is Q5 is negative, FALSE (or 0) if positive. Hence, in the first instance you will multiply Q5 by 1, in the other instance Q5 by zero.
Nickerz_2020 Use =ROUND(SUM(O5:P5),2)
YEP! That worked!!! THANK YOU AGAIN! You are awesome Riny!!!! 😃