IF FORMULA IN EXCEL

The description of IF formula in Excel


The formula of IF function in excel write as IF (logical_test, value_if, value_if_false)
On this column should be fill only tree component, logical_test is any value or expression that can be evaluate as True or False.

For example A10 = 100 this mean that at column A10 on excell have value 100 the expression evaluate as True. Otherwise the evaluation result is False. This only comparison the real value and compare to value at column A10.

Value_if_true its mean that if the value at A10 is True then the logical_test is true. Value if_true can be fill by text string or word such as “Within Budget”, the word “Within Budget” will merge if logical_test argument evaluates as True. But if the value of logical_test is True and value_if_true is blank, this argument will result 0 (zer0).

Value_if _false is other option if the logical_test is False. For example, the result of value_if_false fill by text still for example “Over Budget” this will merge if on the logical_test value is false or wrong. If this value let it blank then (before parenthesis is blank) then the value will get 0 (zero).

Formula if is applied in each cell where you want to use this logical that refer to another cell.
Understood? If still doubt see the picture below:

Formula IF

I write the formula in column C5, the statement says that if the value in column B5 more or similar with 1000 so column in C5 will merge OVER BUDGED, but if I fill column B5 less than 1000 then in column C5 will merge OK. If the formula on the formula bar I write like this =IF(B5>=1000;"Over Budget"), this mean that value_if_false let it blank and the result will 0 (zero) if I fill in column B5 less than 1000.

Comments

Post a Comment

Popular posts from this blog

Cube and Tube Formula

Image
Cube: Cube Volume V = a 3                              (1) where V = volume (m 3  , ft 3  ) a = side (m, ft) Surface Area Ao = 6 a 2   (1b) where Ao = surface area (m 2 , ft 2 ) Diagonal d = a 3 1/2  (1c) where d = innside diagonal (m, ft) Cuboid Tube Volume V = a b c                                    (2) where: V = volume of solid (m 3  , ft 3  ) a = length of rectangular prism (m, ft) b = width of rectangular prism (m, ft) c = height of rectangular prism (m, ft) Diagonal d = (a 2 + b 2   + c 2 ) 1/2                    (2b) Surface Area Ao = 2 (a b + a c + b c)                 (2c) where Ao = surface area of solid (m 2 , ft 2  ) Parallel piped: Parallel Pipped Volume V = A 1 h (3a) where A 1 = side area (m 2 , ft 2  ) Cylinder: Cylinder Volume V = π/4 d 2   h = π r 2 h         (4a) where d = diameter of cylinder (m, ft) r = radius of cylinder (m, ft)
Read more

Statistic Problem

1. Known the number of ball n(s) = 100 Ask: The change take a ball with number divisible by 5 but not divisible by 3 if taken randomly. Answer: For example A = ball with number divisible by 5 but not divisible by 3 n(A) = 14, namely 5, 10, 20, 25, 35, 40, 50, 55, 65, 70, 80, 85, 95 and 100 P(A) = n(A)/n(s) = 14/100 = 7/50 2. Known: One badminton team consist of 5 members, will decide 2 people play a single players, and 2 pairs to play double. Ask: How many option can be made. First Way Solution: For example 5 people of badminton team are A, B, C, D, and E. Then we choose A and B to play single. Option Single Double 1 A, B CD, AE 2 A, B CE, AD 3 A, B  DE, AC 4 A, B CD, BE 5 A, B CE, BD 6 A, B DE, BC The option number when A and B choose as single player are 6 option. The way to choose player as single player are 10, namely AB, AC, AD, AE, BC, BD, BE, CD, CE, and DE. From one option of single player will make 6 option so for all way to choose single
Read more

Phytagoras Formula

Image
A simple formula from pythagoras is calculatef of each side on right triangle as follows: C 2 = A 2 + B 2 Where : C = the incline side length A and B = other triangle side length. For Example calculation can see on picture below: For your excercise please do the following problem: Calculate the length of the hypotenuse if the lenght elbow side 6 and 8? Calculate the length of one side of the elbow if the length of the hypotenuse = 10 and the other 4?
Read more