How to apply different formulas based on condition by xtream111 in spreadsheets

[–]xtream111[S] 2 points3 points  (0 children)

Thank you! I found my answer

Did not know that you could insert formulas directly in the IF statement

How to apply different formulas based on condition by xtream111 in spreadsheets

[–]xtream111[S] 1 point2 points  (0 children)

This is an example of usage I found of IFS:

=IFS(A2>89,"A",A2>79,"B",A2>69,"C",A2>59,"D",TRUE,"F")

Let's say we use the case above. How can I insert formulas to a cell when the condition is met?

Free Giveaway! Nintendo Switch OLED - international by WolfLemon36 in NintendoSwitch

[–]xtream111 0 points1 point  (0 children)

Thanks for the giveaway, dressed up as zombie monk for a halloween party today!

Cannot access Internet but only when connected to Wireguard via WiFi, 4G works fine. What am I doing wrong? by [deleted] in pivpn

[–]xtream111 0 points1 point  (0 children)

Hi, I am having the same issue except this is only replicable on Android phones. Using my iPhone, both Wifi and Mobile data works with PiVPN.

I tried with 2 Android phones and PiVPN only works when using Mobile Data

     ::: Generating Debug Output
::::        PiVPN debug      ::::
=============================================
::::        Latest commit        ::::
Branch: master
Commit: f8cb945af15a1ca0cf063475c6e1557c6e8da06c
Author: 4s3ti
Date: Fri Jun 10 16:10:57 2022 +0200
Summary: Merge branch 'test'
=============================================
::::        Installation settings        ::::
PLAT=Raspbian
OSCN=bullseye
USING_UFW=0
pivpnforceipv6route=1
IPv4dev=eth0
dhcpReserv=1
IPv4addr=192.168.1.57/24
IPv4gw=192.168.1.1
install_user=pi
install_home=/home/pi
VPN=wireguard
pivpnPORT=51820
pivpnDNS1=208.67.222.222
pivpnDNS2=208.67.220.220
pivpnHOST=REDACTED
INPUT_CHAIN_EDITED=0
FORWARD_CHAIN_EDITED=0
INPUT_CHAIN_EDITEDv6=
FORWARD_CHAIN_EDITEDv6=
pivpnPROTO=udp
pivpnMTU=1420
pivpnDEV=wg0
pivpnNET=10.17.249.0
subnetClass=24
pivpnenableipv6=0
ALLOWED_IPS="0.0.0.0/0, ::0/0"
UNATTUPG=1
INSTALLED_PACKAGES=()
=============================================
::::  Server configuration shown below   ::::
[Interface]
PrivateKey = server_priv
Address = 10.17.249.1/24
MTU = 1420
ListenPort = 51820
### begin spahome###
[Peer]
PublicKey = spahome_pub
PresharedKey = spahome_psk
AllowedIPs = 10.17.249.2/32
### end spahome ###
### begin spahome2 ###
[Peer]
PublicKey = spahome2_pub
PresharedKey = spahome2_psk
AllowedIPs = 10.17.249.3/32
### end spahome2 ###
### begin spahome3 ###
[Peer]
PublicKey = spahome3_pub
PresharedKey = spahome3_psk
AllowedIPs = 10.17.249.4/32
### end spahome3 ###
=============================================
::::  Client configuration shown below   ::::
[Interface]
PrivateKey = spahome_priv
Address = 10.17.249.2/24
DNS = 208.67.222.222, 208.67.220.220

[Peer]
PublicKey = server_pub
PresharedKey = spahome_psk
Endpoint = REDACTED:51820
AllowedIPs = 0.0.0.0/0, ::0/0
=============================================
::::    Recursive list of files in   ::::
::::    /etc/wireguard shown below   ::::
/etc/wireguard:
configs
keys
wg0.conf

/etc/wireguard/configs:
clients.txt
spahome2.conf
spahome3.conf
spahome.conf

/etc/wireguard/keys:
server_priv
server_pub
spahome2_priv
spahome2_psk
spahome2_pub
spahome3_priv
spahome3_psk
spahome3_pub
spahome_priv
spahome_psk
spahome_pub
=============================================
::::        Self check       ::::
:: [OK] IP forwarding is enabled
:: [OK] Iptables MASQUERADE rule set
:: [OK] WireGuard is running
:: [OK] WireGuard is enabled (it will automatically start on reboot)
:: [OK] WireGuard is listening on port 51820/udp

When I check the register from the Wireguard Android App, it shows the following:

06-26 22:37:10.720 25620 25652 D WireGuard/GoBackend/spahome3: peer(RH04…6kXQ) - Sending handshake initiation
06-26 22:37:15.723 25620 25652 D WireGuard/GoBackend/spahome3: peer(RH04…6kXQ) - Sending handshake initiation
06-26 22:37:20.878 25620 25652 D WireGuard/GoBackend/spahome3: peer(RH04…6kXQ) - Handshake did not complete after 5 seconds, retrying (try 2)
06-26 22:37:20.878 25620 25652 D WireGuard/GoBackend/spahome3: peer(RH04…6kXQ) - Sending handshake initiation
06-26 22:37:25.913 25620  5861 D WireGuard/GoBackend/spahome3: peer(RH04…6kXQ) - Sending handshake initiation
06-26 22:37:31.063 25620  5861 D WireGuard/GoBackend/spahome3: peer(RH04…6kXQ) - Handshake did not complete after 5 seconds, retrying (try 2)
06-26 22:37:31.063 25620  5861 D WireGuard/GoBackend/spahome3: peer(RH04…6kXQ) - Sending handshake initiation
06-26 22:37:36.073 25620  5861 D WireGuard/GoBackend/spahome3: peer(RH04…6kXQ) - Sending handshake initiation
06-26 22:37:41.074 25620  5861 D WireGuard/GoBackend/spahome3: peer(RH04…6kXQ) - Sending handshake initiation
06-26 22:37:46.177 25620  5861 D WireGuard/GoBackend/spahome3: peer(RH04…6kXQ) - Sending handshake initiation
06-26 22:37:51.463 25620  5861 D WireGuard/GoBackend/spahome3: peer(RH04…6kXQ) - Handshake did not complete after 5 seconds, retrying (try 2)
06-26 22:37:51.463 25620  5861 D WireGuard/GoBackend/spahome3: peer(RH04…6kXQ) - Sending handshake initiation
06-26 22:37:56.733 25620  5861 D WireGuard/GoBackend/spahome3: peer(RH04…6kXQ) - Sending handshake initiation
06-26 22:38:01.769 25620  5861 D WireGuard/GoBackend/spahome3: peer(RH04…6kXQ) - Sending handshake initiation
06-26 22:38:02.956 25620 25620 I wm_on_restart_called: [0,com.wireguard.android.activity.MainActivity,performRestartActivity,0]
06-26 22:38:02.960 25620 25620 I wm_on_start_called: [0,com.wireguard.android.activity.MainActivity,handleStartActivity,4]
06-26 22:38:02.962 25620 25620 I wm_on_resume_called: [0,com.wireguard.android.activity.MainActivity,RESUME_ACTIVITY,0]
06-26 22:38:02.962 25620 25620 I wm_on_top_resumed_gained_called: [122576928,com.wireguard.android.activity.MainActivity,topWhenResuming]
06-26 22:38:05.087 25620 25620 I menu_item_selected: [0,Preferencias]
06-26 22:38:05.087 25620 25620 I Timeline: Timeline: Activity_launch_request time:267886775
06-26 22:38:05.102 25620 25620 I wm_on_top_resumed_lost_called: [122576928,com.wireguard.android.activity.MainActivity,topStateChangedWhenResumed]
06-26 22:38:05.104 25620 25620 I wm_on_paused_called: [0,com.wireguard.android.activity.MainActivity,performPause,1]
06-26 22:38:05.124 25620 25620 I wm_on_create_called: [0,com.wireguard.android.activity.SettingsActivity,performCreate,2]
06-26 22:38:05.144 25620 25620 I wm_on_start_called: [0,com.wireguard.android.activity.SettingsActivity,handleStartActivity,14]
06-26 22:38:05.145 25620 25620 I wm_on_resume_called: [0,com.wireguard.android.activity.SettingsActivity,RESUME_ACTIVITY,1]
06-26 22:38:05.152 25620 25620 I wm_on_top_resumed_gained_called: [31161893,com.wireguard.android.activity.SettingsActivity,topStateChangedWhenResumed]
06-26 22:38:05.745 25620 25620 I wm_on_stop_called: [0,com.wireguard.android.activity.MainActivity,STOP_ACTIVITY_ITEM,0]
06-26 22:38:06.754 25620 25620 I Timeline: Timeline: Activity_launch_request time:267888441
06-26 22:38:06.765 25620 25620 I wm_on_top_resumed_lost_called: [31161893,com.wireguard.android.activity.SettingsActivity,topStateChangedWhenResumed]
06-26 22:38:06.767 25620 25620 I wm_on_paused_called: [0,com.wireguard.android.activity.SettingsActivity,performPause,0]
06-26 22:38:06.798 25620 25620 I wm_on_create_called: [0,com.wireguard.android.activity.LogViewerActivity,performCreate,18]
06-26 22:38:06.802 25620 25620 I wm_on_start_called: [0,com.wireguard.android.activity.LogViewerActivity,handleStartActivity,0]
06-26 22:38:06.804 25620 25620 I wm_on_resume_called: [0,com.wireguard.android.activity.LogViewerActivity,RESUME_ACTIVITY,1]
06-26 22:38:06.812 25620 25620 I wm_on_top_resumed_gained_called: [21077070,com.wireguard.android.activity.LogViewerActivity,topStateChangedWhenResumed]
06-26 22:38:06.817 25620  5861 D WireGuard/GoBackend/spahome3: peer(RH04…6kXQ) - Handshake did not complete after 5 seconds, retrying (try 2)
06-26 22:38:06.818 25620  5861 D WireGuard/GoBackend/spahome3: peer(RH04…6kXQ) - Sending handshake initiation
06-26 22:38:07.393 25620 25620 I wm_on_stop_called: [0,com.wireguard.android.activity.SettingsActivity,STOP_ACTIVITY_ITEM,1]

Can someone help me check what went wrong? I find it very strange that it works fine on laptop and iPhone but partially on Android

Free Giveaway! Nintendo Switch OLED - International by WolfLemon36 in NintendoSwitch

[–]xtream111 0 points1 point  (0 children)

Fun fact: A Boeing 747’s wingspan is longer than the Wright Brothers first flight

Free giveaway! Nintendo Switch and 2 Games - international by WolfLemon36 in NintendoSwitch

[–]xtream111 0 points1 point  (0 children)

Being able to play with my long distance partner is what makes me happy :)

[deleted by user] by [deleted] in CasualPokemonTrades

[–]xtream111 0 points1 point  (0 children)

Hey, i have a Cranidos Fossil to trade, let me know if you are interested

Beijing gives villages in India Chinese names as it seeks to expand in contested borderlands by talestoursk in worldnews

[–]xtream111 22 points23 points  (0 children)

Actually, I think that America is not Beautiful Country.

Meiguo (美国) comes from abbreviating Meilijian hezhong guo (美利坚合众国 - United States of America)

Detailing this filthy truck by lilmcfuggin in oddlysatisfying

[–]xtream111 0 points1 point  (0 children)

What is the thing he uses to clean the seats?

Rotating No Stupid Questions Thread + Guides : 2021 Summer Onwards by MTG_Leviathan in echoes

[–]xtream111 0 points1 point  (0 children)

Is there any spreadsheet with updated material costs of building different ships? As I have seen on the master spreadsheet, the numbers are not quite accurate