Ask Your Question
0

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

asked 2013-11-15 18:09:28 +0100

jmolero gravatar image

updated 2015-10-26 22:04:41 +0100

Alex Kemp gravatar image

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 flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-10-26 22:05:05.174355

1 Answer

Sort by » oldest newest most voted
0

answered 2013-11-15 18:18:56 +0100

carnendil gravatar image

updated 2013-11-15 18:47:47 +0100

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)
edit flag offensive delete link 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)

jmolero gravatar imagejmolero ( 2013-11-15 18:31:00 +0100 )edit

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.

carnendil gravatar imagecarnendil ( 2013-11-15 18:45:42 +0100 )edit

Question Tools

1 follower

Stats

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

Seen: 6,191 times

Last updated: Nov 15 '13