computer






 

Question by  Sindhuramesh (21)

What is the formula in Excel for If then greater and lesser?

I need help in Excel.

 
+7

Answer by  physicsBot (18)

Symbols for comparison (use angle brackets not parentheses, though) ( strictly less than ) strictly greater than (= less or equal )= greater or equal (c, x, y) This expression is made up of a conditional statement and two values. If conditional c is true, it equals x. If not, it equals y. Remember-always start Excel formulas with =.

 
+7

Answer by  tsree (18)

IF(logical_expression, exp1, exp2) If logical expression is true exp2 will be result, otherwise exp1 will be. eg: if(a1>5, 12, 35)

 
+7

Answer by  jr22 (59)

How Microsoft Excel IF functions are entered, Less Than =IF(Value ComparedValue, Answer if True, Answer if False)

 
+5

Answer by  shichi (30)

this is actually the formula in excel if you're using "If" then greater and lesser =IF(A1 > 5, "Greater than Five", "Less than Five")

 
+5

Answer by  Halgali (62)

The formula is written as =if(logical_test,value_if_true,value_if_false) For Example, value1 = 3, value2 = 2, then the below formula =if(value1>value2,"true","false") will have answer "true" in the cell where this formula exists.

 
+5

Answer by  NarenMukherjee (308)

IF cell value is LESS than 100, then 2+2, if GREATER than 100, then 3+2, then the formula would be =IF(E37>100, G35/50*G35), IF(E37<101,G35/100*G35))

 
+4

Answer by  vijayparttimejob (2254)

this is the formula for your question: =IF([cell id]>15,"cell value is greater than 15 ", IF([cell id ]<15,"the cell id value is lesser than 15")). here cell is value is compared with the value 15, if the condition is true , the result is greater else it will check the another if like same above if

 
You have 50 words left!