Ask Your Question

# CALC: How to show text within a cell using IF function? [closed] hello to all,

i am using the IF function and i have to show the content of a cell when the function is true. The text is alphanumeric

i.e

IF (H7>0;B7;""). In case that the cell H7 is bigger than zero, the result of the function should be the text within the cell B7... and the result of the operation is 0 (zero).

Is there any way to show the text within the cell B7?

Thanks,

edit retag reopen merge delete

## 1 Answer

Sort by » oldest newest most voted You introduce the formula:

=IF(H7>0,B7,0)


In this case, if H7 is greater than 0, whatever is in B7 will be shown. If H7 is lower or equal than 0, the value "0" will be shown.

If you want the "0" to appear when H7 is greater than 0 and the text in B7 when H7 is lower or equal than 0, you would use:

=IF(H7>0,0,B7)

more

## Comments

I know i can introduce the text between " " but what i want is to display the text in the specified text.

I mean with the result of the operation, that writing IF (H7>0; B7;""); when H7>0, instead of showing the text i.e berenjena, it shows 0 (zero)

If I understand right, you have at least three cells of interest here: B7 with some text, H7 with some numbers, and a third one where you want to show, either the same text as in B7 (when H7>0) or the number "0" (when H7<=0). Am I right? See edited answer.

## Stats

Asked: 2013-11-15 18:09:28 +0200

Seen: 6,623 times

Last updated: Nov 15 '13