Forum Discussion

Nickerz_2020's avatar
Nickerz_2020
Brass Contributor
May 13, 2021
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 ...
Formulas and Functions
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    May 14, 2021

    Nickerz_2020 

    Try this:

    =(N5+Q5*(Q5<0))*C5+B6

     The 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.

NikolinoDE's avatar
NikolinoDE
Platinum Contributor
May 13, 2021

Nickerz_2020 

With everyone's permission, here is a comparison of the formulas.

So press Mr. Nick G, Riny van Eekelen's formula, with Like, and mark it as the correct answer :)).

...it will be beneficial to more Community members reading here.

 

 

Thank you for your understanding and patience

 

 

Nikolino

I know I don't know anything (Socrates)

Resources