Easy way to make highly nested conditionals

Forum rules
No question in this forum please
For any question related to a topic, create a new thread in the relevant section.

Easy way to make highly nested conditionals

Postby Bald Eagle » Fri Jan 19, 2018 11:57 pm

I've been working with OpenOffice Calc for a while now, and found myself wanting to process some data that required a lot of if-then-else type conditions.
I found the edit-in-cell [Ctrl][Enter] trick to add line breaks in the formula to make it more readable, but something caught my eye and I had an "aha!" moment.

The only real condition you're focusing writing in the current cell is the IF portion. Else could be the result of some other test in another cell.
And that could go on an on, chaining them together.
So I "stacked" the conditional cells, and the added benefit of this was that by just copying the formula up one cell, another layer could be added to the nested conditional.
Delete the top cells, and the outer layer of the nest is removed. Super simple.

I made a little spreadsheet to demonstrate.
Questions, comments, constructive criticism, and improvements are most welcome.
Attachments
Nested_Conditionals.ods
(15.54 KiB) Downloaded 114 times
OpenOffice 4.1.1 on Windows 7
Bald Eagle
 
Posts: 50
Joined: Wed Apr 19, 2017 9:22 pm

Re: Easy way to make highly nested conditionals

Postby njhub » Wed Sep 12, 2018 9:28 pm

Hi Bald Eagle,

Thank's for your spreadsheet.

Can you update it with, so it will be easier to read, with a sentence according true/false
Code: Select all   Expand viewCollapse view
=SI(B8;"Input cell is empty";"Input cell isn't empty")&T(STYLE(SI(B8;"GreenStyle";"RedStyle")))
LibreOffice Version: 6.1.1.2 (x64) (fr) on: Windows 10.0
njhub
 
Posts: 18
Joined: Thu May 17, 2018 8:36 am
Location: Mayotte YT


Return to Calc

Who is online

Users browsing this forum: No registered users and 3 guests