206551/excel-if-field-with-rounding

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.

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

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

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

Use this: =IF(SUMPRODUCT(--(LEFT(G3,1)={"1","2","3"}))>0,"998", ...READ MORE

Here's a sample LINQPad program that demonstrates one way ...READ MORE

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

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

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

I'm not sure if it is a ...READ MORE

What about using mid() to see if ...READ MORE

OR

At least 1 upper-case and 1 lower-case letter

Minimum 8 characters and Maximum 50 characters

Already have an account? Sign in.