IF Function, can you help?

Question

I am doing an IF Function in excel and I need the result to come back with Photo or Blank cell. How do I do this as a zero keeps coming in the other cells?

ok, here's what I have to do:

If the cost is more than £80,they get a free photo. I need to enter a formula that will produce the comment "Photo if it is greater than £80. If not, the cell must be blank. This is what i have done:
=IF(J10>80,"Photo",)
I don't know what to put at the end for a blank cell. It has returned a zero if not photo.

Answer 1

add "" (two quotation marks) as "otherwise" statement i.e.

=IF(J10>80,"Photo","")

The "" will show a blank cell if J10<80.

Answer 2

With an if function you need to look up a particular cell to see if it is true of false. Using the following example will make it clear. For example if I want the word Photo to be shown if the value in cell b4 is 23 then I will need to use the following formula:

=IF(B4=23,"Photo"," ")
With this, if the value is 23 then the word photo will be shown, however if the value is not 23 then the cell is left blank as I entered the false value to be " ".

For your spreadsheet you need to use the formula like I have above but you will probably need to change the cell that you are looking up from B4 and also the value that you want from 23.

Just read your additional details, the formula you need to enter is:

=IF(J10>80,"Photo"," ")

Answer 3

The IF function does a test on the formula you set. You then have to set two results for true and false.

See F1 help and IF

Returns one value if a condition you specify evaluates to TRUE and another value if it evaluates to FALSE.

Use IF to conduct conditional tests on values and formulas.

Syntax

IF(logical_test,value_if_true,value_if_false)

Logical_test is any value or expression that can be evaluated to TRUE or FALSE. For example, A10=100 is a logical expression; if the value in cell A10 is equal to 100, the expression evaluates to TRUE. Otherwise, the expression evaluates to FALSE. This argument can use any comparison calculation operator.

Value_if_true is the value that is returned if logical_test is TRUE. For example, if this argument is the text string "Within budget" and the logical_test argument evaluates to TRUE, then the IF function displays the text "Within budget". If logical_test is TRUE and value_if_true is blank, this argument returns 0 (zero). To display the word TRUE, use the logical value TRUE for this argument. Value_if_true can be another formula.

Value_if_false is the value that is returned if logical_test is FALSE. For example, if this argument is the text string "Over budget" and the logical_test argument evaluates to FALSE, then the IF function displays the text "Over budget". If logical_test is FALSE and value_if_false is omitted, (that is, after value_if_true, there is no comma), then the logical value FALSE is returned. If logical_test is FALSE and value_if_false is blank (that is, after value_if_true, there is a comma followed by the closing parenthesis), then the value 0 (zero) is returned. Value_if_false can be another formula.

Answer 4

=IF(J10>80,"Photo"," ")
Or, go to
Tools, View tab and uncheck the Zero Values check box. This will hide all zero values in the sheet.

Answer 5

You need to add an expression to your formula to tell it what to do if the first criterion isn't met. In your case, after the comma you'd type " " ie. quotesspacequotes.

Your formula will be =IF(J10>80,"Photo"," ")

Us ancient DOS users will remember this as IF so and so, THEN do so and so,ELSE do something else.

Say after me "If Then Else, If Then Else,If Then Else,If Then Else,If Then Else,If Then Else,If Then Else, . . . . . "

Answer 6

Sounds like you have set the "otherwise" as a "0"
the result will be "0". I'm not certain you did this.

=IF(A1= (criteria), "Photo", "")

After the criteria is tested, a comma means "Then"
print "Photo". Photo must be enclosed in parenthesis as all text must.
Then a comma means "otherwise" place a void, by using two quotation marks.

Answer 7

this is a simple one, =if(cell being looked at=any blank cell on spreadsheet,"blank cell","photo")

example if cell A1 is the cell u wanna look at and G1 is a blank cell =if(a1=$g$1,"blank cell","photo")