I'm average at Excel and this one has me stumped.

What I'm trying to do is calculate if a cell is 0 return a figure of 0, if the cell is greater than 0 but less than 61 (eg 60) return .15, if the cell is greater than 61 then divide the cell by 60 and round up to the next whole number eg if the cell is 86 the figure returned from the divide is 1.433 so I want that rounded to 2.

Sep 26, 2022 in Others 502 views

## 1 answer to this question.

Here's your formula. Assumes your cell containing the value to be evaluated is A2.

```=IF(ISNUMBER(A2),IF(VALUE(A2)<=0,0,IF(VALUE(A2)<=61,0.15,ROUNDUP(VALUE(A2)/60,0)*0.15)),"0")
```

Here are the test results for all your conditions.

• 63,420 points

## How to merge two cells in excel with same field name

Insert 2 new columns, G & H. Enter ...READ MORE

## Help needed with Median If in Excel

Try entering the formula =MEDIAN(IF(\$A\$1:\$A\$6="Airline",\$B\$1:\$B\$6,"")) in another ...READ MORE

## Excel - IF combined with Index Match

Try: =IFERROR(IF(ISNUMBER(O2),VLOOKUP(A2,Sheet2!\$C\$2:\$E\$10,3,FALSE),""),"") =IFERROR(IF(ISNUMBER(O2),INDEX(Sheet2!\$E\$2:\$E\$10,MATCH(A2,Sheet2!\$C\$2:\$C\$10,0)),""),"") where the first "" means that O2 is not a number, ...READ MORE

## IF formula to compare a date with current date and return result

You can enter the following formula in ...READ MORE

## Excel Formula - if values in columns all contain X then return

You can use the AND function: = IF(AND(A3="OK";B3="OK";C3="OK");"everything ...READ MORE

## (Excel) If cell is greater than <condition> then minus <number>

The IF function to calculate B5 (amount ...READ MORE