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)
- Help with chat server
- Connect 4 or Four in a row help
- Need help on jvm
- xml help getting started
- Problem installing DrJava- Can someone please help?
- help with Thread security
- Help WIth Packages
- Please help me compiling this java program
- Help with Sun Model 2
- SMSJDK HELP
- Need help
- JSP-HTML+POSTGRES HELP
- help with tomcat configuration
- Help with error- UDP
- help me with temp internet folder
- Help finding EOF
- Need help in PcDOC file format
- Need helps on J2EE Installation
- need help to scan an image
- need help/voice chat
- Need help with this code
- Need some help with coding