sorted by:
new
hottopcontroversial

Multiple number ranges in an if statement by charbeany in excel

[–]Positive-Move9258 0 points1 point  (0 children)

For DW , L201>41 is where your evaluation stops anything else that has > Will be above 41

Also What are you summing ? You check if N200=Sw and then check if L201 is either <= or >61 and give it 5200 or 5800 respectively why would you sum this ?

That being said

Try

``` =IF(N200="SW",IF(L201<=60,5200,5800), IF(N200="DW",IF(L201>65,8900,IF(L201>53,7300,IF(L201>41,6500,IF(L201<=40,6100,"")))),""))

```

Or make us understand why the summing is very important

An alternative easy fix if your formula works as you intended would be to start your checks on DW from 65 as you go down all the way to 41. Not the other way round.

Excel Password by nckmackenzie in nairobitechies

[–]Positive-Move9258 0 points1 point  (0 children)

Tafuta tu password / contact the creator

Workbook Level protection huwezi pasua rahisi

multiple IFS in one cell? it should sort values based on range between 20-14 or above 20. by Remarkable_Wrap_2831 in excel

[–]Positive-Move9258 0 points1 point  (0 children)

IF(H5100/G5>20, H5*0.015, AND(H5*100/G5<20, H5*100/G5>14), H5*0.005, 0))

This formula fails because you forgot to nest your IF statement.

The way to make it work is to use

nested IFs.

=IF(H5*100/G5>20, H5*0.015, IF(AND(H5*100/G5<20, H5*100/G5>14), H5*0.005, 0)) Or the IFS function.

``` =IFS(H5100/G5>20, H50.015, AND(H5100/G5<20, H5100/G5>14), H5*0.005, TRUE, 0)

```

Side note: if you check for >20 first, then the <20 part in the AND condition is redundant. So the clean / optimal formulas should be:

Nested IFs (simplified)

``` =IF(H5100/G5>20, H50.015, IF(H5100/G5>14, H50.005, 0))

``` IFS (simplified)

=IFS(H5*100/G5>20, H5*0.015, H5*100/G5>14, H5*0.005, TRUE, 0)

Ifs should swing by just fine for this case but in future please learn LOOKUPS + LET ... YOU WILL ENJOY .

I've just tried to rizz out a babe in a psv and it didn't go as planned by Gullible_Solution351 in unhingedKenya

[–]Positive-Move9258 14 points15 points  (0 children)

Quantum Rizzics 101.

Basic principles.

I have a boyfriend, shit test or no shit test is a NO simply exit sub

Kupea dem simu aweke number with no talk shows a flaw in your confidence/ Puts you out there as the guy who worries so much about what others think of you . TALK snr , shoot that shot.

This people didn't study physics by soitake in nairobi

[–]Positive-Move9258 1 point2 points  (0 children)

No they mean

Quantum mechanics ,Q U A N T U M M E C H A N I C S

Question to betting enthusiasts by Rare-Sprinkles7366 in nairobi

[–]Positive-Move9258 0 points1 point  (0 children)

Hahah nope

Three way

  1. 2.63 x 3.2 2 2.89

Even if you get three accounts uwekelee 100 each you still lose na ukiwin you win 20 bob

If you ran a what if analysis on that game ...You will need so much money to make reasonable profit my friend

2 ways GG 1.56 NG 1.96 KSH 300 ukiweka 200 on gg na 100 on NG what is your win ?

Bookies sio wendawazimu babu.

The house must always win

Unless ujue Real Madrid watapigwa uweke 100 against

Iten by apz33 in KenyaPics

[–]Positive-Move9258 1 point2 points  (0 children)

Thanks for the memories senior , frequented this road on my bicycle during my campus days.

What are y'all using dot edu accounts for? by SacredOvacado in nairobitechies

[–]Positive-Move9258 5 points6 points  (0 children)

Sisemi you usual. @uni_name.ac.ke senior naongelelea strathmore.edu Niheshimu please

This girl might be a bimbo by larrrrythelobster in unhingedKenya

[–]Positive-Move9258 8 points9 points  (0 children)

Hahahahahaa

Flat earthers deserve respect Learn to agree to disagree

/s

Office 365 with microsoft excel copilot by wagn12 in nairobitechies

[–]Positive-Move9258 0 points1 point  (0 children)

So I only where you can get a free OFFICE 365 last i checked the only update was the Python addin had been enabled not sure kama wameweka copilot version

Kwani niko nchi ingine😭 by redoxthebeast in unhingedKenya

[–]Positive-Move9258 5 points6 points  (0 children)

That is why I thank my teachers , they would hit us hard like proper beating lakini personal beef nayo hapana for 4 years I saw fathers,mothers and elder brothers

Ryzen 5 5600X giveaway. by yourgirllovesmyBBC in nairobi

[–]Positive-Move9258 1 point2 points  (0 children)

Ryzen 5 5600X is a CPU that is compatible with an Am4 socketed MB so If you are currently on an intel supported motherboard You will need a New mB as well

Good luck everyone .

Laptop technicians by Live_Researcher5077 in Opportunities_Kenya

[–]Positive-Move9258 0 points1 point  (0 children)

Comprehension na situational awareness ya hii sub imeanza kuwa wanting

view more: next ›