Why advantage is there in using "if' statements

**Mrrickc** · 03-22-2015, 02:16 PM

What is the advantage of using an if statement instead of just creating a formula?

Example:

Worksheet 1
Cell A11 contains 150
Cell A12 contains 100

Cell A14 contains this formula =If(A11,(A11-A12)/A11,"") which returns .3333333 in cell A14

Worksheet 2
Cell B11 contains 150
Cell B12 contains 100

Cell B14 contains this formula =sum (B11-B12)/B11 which also returns .3333333 in Cell B14

What is the advantage of using the "If" Statement over a regular formula?

Thanks

Rick

**TMS** · 03-22-2015, 02:20 PM

With the second one, you will get a divide by zero error (#DIv/0!) if B11 is blank. With the first one, you won't. You'll get a blank if A11 is blank or zero.

Your choice: error or no error. That's the difference.

Regards, TMS

**TMS** · 03-22-2015, 02:21 PM

And you don't actually need SUM in the second example.

**bebo021999** · 03-22-2015, 02:21 PM

Try to delete A11, you can see the advantage.

Why advantage is there in using "if' statements

LinkBack

Thread Tools

Rate This Thread

Display

Why advantage is there in using "if' statements

Re: Why advantage is there in using "if' statements

Re: Why advantage is there in using "if' statements

Re: Why advantage is there in using "if' statements

Thread Information

Users Browsing this Thread

Similar Threads

Any advantage to "trim" over "find/replace" for eliminating spaces?

Need some help with "nested if statements function" & "classifiying the group category"

7 nested IF statements with a SEARCH added IF(ISNUMBER(SEARCH({"INSUR","AP REFUND"}

Case Select statements with "if" statements

what is an advantage of using a model?

Bookmarks

Bookmarks

Posting Permissions