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.

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
May 20, 2021

Nickerz_2020 The comment regarding a new thread was a tip for the future. Anyway, in the Trust Center (File, Options) you can change the settings. You'll see that "Enable automatic update of links is NOT RECOMMENDED.

Nickerz_2020's avatar
Nickerz_2020
Brass Contributor
May 20, 2021

Got it, thanks for the tip Riny and the quick reply!

I guess I'm confused as to why this suddenly started happening. ? I don't share this spreadsheet and I've only been updating the formulas from these forums, which is why I thought this has something to do with the recent formulas I copied and pasted.

I opened my Trust Center and I have all the default options that you show in your screenshot above but to try to get rid of the pop up window (which now happens each time I open my spreadsheet, no matter which option I choose, update/don't update) I tried selecting "Disable..." for the 3 options above but I'm still being prompted to update/don't update for the latest data. ????

Again, I'm just confused as to what my spreadsheet is trying to do but even more confused as to why I'm now having to deal with this when I haven't changed any of these settings. Just weird...

 

 

 

***UPDATE***
Just now, I clicked on the Data tab>Existing Connections but found none (see attached screenshot below...)

 

So then I tried Data>Edit Links>Break Link

 

...and it pops up a warning, I then clicked on Break Links (since I have another copy of this spreadsheet saved) and I'm no longer prompted to Update the links!

 

My spreadsheet looks fine as do the formulas (as far as I can tell at the moment) but again, I have NO idea how this issue started. ? Just came out of left field all of a sudden. ?????

 

 

Resources