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,
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)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.