Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Can you help?

  Asked By: Raju    Date: Aug 24    Category: MS Office    Views: 451
  

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.

Share: 

 

3 Answers Found

 
Answer #1    Answered By: Woodrow Jones     Answered On: Aug 24

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)

 
Answer #2    Answered By: Iris Sanders     Answered On: Aug 24

B3 - =IF(B2>B1,B2-B1,"")

B4 - =IF(B2<B1,B1-B2,"")

"Do you think I am suppose to make up some amount?"

"We shall look at the last part  of our income tax forms."

Were you given some kind of income tax form to use in this project,
to give you the dollar values  for column  A?

 
Answer #3    Answered By: Olga Allen     Answered On: Aug 24


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.




Tagged: