Ask Your Question

Inve1963's profile - activity

2020-08-07 20:38:31 +0100 received badge  Famous Question (source)
2020-08-05 00:54:53 +0100 received badge  Notable Question (source)
2020-04-30 18:22:54 +0100 received badge  Popular Question (source)
2020-04-30 02:07:55 +0100 received badge  Supporter (source)
2020-04-30 02:07:54 +0100 marked best answer When using an =IFS statement Some of the results display N/A Even though it looks like there are no problems

The Statement: =IFS(D2<5 AND(F2-E2<2) ,"Easy",D2>=5 OR(D2<10) AND(F2-E2>=2 OR(F2-E2<=4)),"Semi hard",D2>=10 AND(F2-E2>4 OR(F2-E2<6)),"hard",D2>=11 AND(F2-E2<9),"Sucks",D2>=100,"How?")

One of the N/A output Column info is D2=4 F2=8 E2=4

2020-04-30 01:52:49 +0100 commented answer When using an =IFS statement Some of the results display N/A Even though it looks like there are no problems

That helps a lot but what do I do for the ORs? Thank you For fixing most of the Errors on my sheet I encountered though,

2020-04-29 21:53:50 +0100 marked best answer What cells is a style applied to

I have a Calc document that I created some months ago containing several messed-up styles. Now I need to fix it and I would prefer not to rebuild it from scratch but I can't remember how I created and assigned the styles. Is there an easy way to check what cells I applied each style to?

2020-04-29 21:53:50 +0100 received badge  Scholar (source)
2020-04-29 21:48:58 +0100 received badge  Organizer (source)
2020-04-29 21:36:01 +0100 asked a question When using an =IFS statement Some of the results display N/A Even though it looks like there are no problems

When using an =IFS statement Some of the results display N/A Even though it looks like there are no problems The Stateme

2020-01-22 12:00:05 +0100 received badge  Notable Question (source)
2020-01-20 09:50:17 +0100 received badge  Popular Question (source)
2020-01-19 21:12:41 +0100 received badge  Notable Question (source)
2020-01-19 21:12:40 +0100 received badge  Notable Question (source)
2020-01-19 21:12:20 +0100 received badge  Notable Question (source)
2020-01-19 21:12:20 +0100 received badge  Famous Question (source)
2020-01-19 21:12:20 +0100 received badge  Popular Question (source)
2019-11-12 13:22:00 +0100 received badge  Popular Question (source)
2019-09-19 10:01:54 +0100 received badge  Popular Question (source)
2019-09-14 11:41:07 +0100 asked a question Tagliare celle senza perdere la formattazione|Cambio font predefinito

Tagliare celle senza perdere la formattazione|Cambio font predefinito Salve, In calc ogni volta che taglio le celle (co

2019-07-21 08:17:13 +0100 asked a question Modulo-formulario con campi calcolati automaticamente

Modulo-formulario con campi calcolati automaticamente Ho bisogno di creare un modulo con dei valori calcolati in automat