if-statementgoogle-sheetsgoogle-sheets-formularoundingnested-if
How to round to a speicific number
I assume this may be an easy task, I have tried searching in the community, but can't find the one which I am looking for, so i have some numbers and want to round to a specific number,
| BEFORE | AFTER ROUNDED |
|---|---|
| 431 | 435 |
| 432 | 435 |
| 433 | 435 |
| 434 | 435 |
| 435 | 435 |
| 430 | 429 |
| 436 | 439 |
| 437 | 439 |
| 438 | 439 |
| 439 | 439 |
| 440 | 439 |
So, if the last digit is between 1-5 it will be i.e. 432 becomes 435; while 437 becomes 439. Also a sample data shown above, i have tried using MROUND or FLOOR Function but not getting through it, any way to get around this
Solution
try:
=ARRAYFORMULA(
IF(REGEXMATCH(INT(X9:X14)&""; ".+[1-5]$"); REGEXEXTRACT(INT(X9:X14)&""; "(.*)\d$")&5;
IF(REGEXMATCH(INT(X9:X14)&""; ".+[0]$"); INT(X9:X14)-1; REGEXEXTRACT(INT(X9:X14)&""; "(.*)\d$")&9))*1)
- Get first non-empty cell in row
- An "and" operator for an "if" statement in Bash
- Checking for character in a string
- VB6 and VB.net has different outcomes with the same IF statements
- Returning Values to Razor Page - Confused Javascript or .cs?
- Excel VBA - how do I get the RowSource of a ComboBox to change depending on the value of another Combobox?
- comma operator in if condition
- How to assign values to a df$column from another df using conditions in R
- Else if statement to create a new column
- How can I run code If any one of if else statements is true?
- zsh condition on number results in bad pattern
- Cobol - checking for remainder in IF clause
- Can you store a variable inside a if-clause?
- How to use the @if angular with async pipe and alias for else block?
- Condition in python lists comprehensions
- nested ifelse in R with "condition has length > 1" warning
- Best practices for integrating optional arguments in shell command inside a snakemake pipeline
- Using joins and if statements
- Using Conditional Statements in Dymola
- Declaring a Variable in if-Statement
- Oracle sql return true if exists question
- How do I replace words in an HTML page using JS?
- How to automate a series of similar IF statements
- How to check a pattern in a string in matlab?
- If statement isn't showing console.log when condition passed and continue work as unexpected
- Order of Conditions in `if ... else if ... else ...` in C++
- How can I assign NA?
- How to return in an Async Function in Angular?
- Why does python use 'else' after for and while loops?
- Calculating my tax automatically in Excel