Search: | |||||

| ||||

Home » Forum » MS Office | RSS Feeds |

I am new at Excel and am trying to do this assignment but can not figure

what is meant by the value? Do you think I am suppose to make up some

amount?

Thanks

Felling dumb and dumber

The If Statement

Spreadsheets can perform logical operations by using the =IF function. The

logic is based on the premise that if something is not true than it must be

false. The following are the methods of comparison.

< is less than

> is greater than

= is equal to

<= is less than or equal to

>= is greater than or equal to

<>does not equal

The formula must start with an =IF. The format for this formula is:

=IF(Condition, argument if true, argument if false)

The condition is separated from the true argument by a comma, and then the

false argument is separated by another comma. It must always follow the

same sequence. Lets look at an example that causes us to cringe every year,

income tax:

We shall look at the last part of our income tax forms. In a new

spreadsheet please enter the following in cells A1 to A4:

A1 – Income Tax paid

A2 – Income Tax owed

A3 – Refund

A4 – Balance Due

We will enter the values and formulas in column B.

In B3 we have to enter a formula that will ask if B1 is greater than B2.

If it is, we will want to print the difference, if not we will want to print

nothing (leave the cell blank). The formula will look like the following

=IF(B1>B2,B1-B2,””)

In this formula the condition is if B1 is greater than B2, if it is than the

true answer is B1-B2, if it is not true than print nothing by typing two

quotation marks.

I would like you to put in the appropriate formula in B4.

Another way of looking at this if/then function:

B4=IF(B1>B2,B1- B2,ï¿½ï¿½)

is to use the logical result of the comparison (B1>B2) and multiply it against

(B1-B2)....

B4=(B1>B2) * (B1-B2)

From a worksheet perspective:

When the condition (B1>B2) is true: (7>5),

the boolean result of 'True' is functionally =1.

When the condition (B1>B2) is false: (5>7)

the boolean result of 'False' is functionally =0.

When the condition (B1>B2) is false: (5>5)

the boolean result of 'False' is functionally =0.

So, you'll return the 2 logical/numeric conditions/expressions:

B4= (1)*(B1-B2)

or

B4=(0)*B1-B2)

No, no value amount and that is what is confusing me.

Didn't find what you were looking for?
Find more on Can you help?
Or get search suggestion and latest updates.

Related Topics:

- Help on a designing the help Screen
- pleass i want 2 help this Question.....so plz help me.....
- can any1 help me in my project? i need some help..(JAVA)
- DropDownList help
- Help w/ Design/Coding Tip
- Help regarding using XML in java
- Help Regarding adding tag in Xml file Using DOM parser
- help : java.util.concurrent.*;
- needing help in using hibernate
- need help about the SHA Message Digest ?
- help regarding dynamic display of dropdown list
- please help nested exception
- help me about ajax
- help needed fast (for websphere portal with javascript)
- help(how to do instant messenger in java or j2ee)
- Help Needed
- Help in java
- help/in java
- help with axis
- Want Help for "Rational Rapid Developer"
- need help for weblogic 7.0
- XMLType - Help needed...
- Help Package,Deploy and Run EJB in Weblogic6.1
- WSAD installation help
- iPlanet Messaging server install help