Dear pro office user out there,i need your help

with some excel problem. The problem is like

this, i am using this function

= IF(AF37="0"," ",AF37) in cell H30

the cell af37 is the sum of three other cell

added together. When the addition is equal to

zero, i want cell H30 to appear as " " (space

bar) if not it will appear as the value shown on

AF37. However the problem is that when the 3

value added together in AF37 = zero, it do not

return as " "(space bar) in cell H30.

Could anyone enlighten me a bit? thanks alot

=)

When you enclose the 0 (zero) in quotes, Excel thinks you mean the text string 0, not the value 0. Remove the quotes and you should be fine.

= IF(AF37=0," ",AF37)

P.S. Do you really want a space " " or do you want an empty cell ""?

Excel will treat a " " differently than a "", so it depends on what you doing with H30 when deciding which to use.

YESH!! you are my saviour haha.. hmm its like this.. i'm working

on this excel spreadsheet that has already a if rule that state if

that box is " "(space bar) it will return a space bar so its empty.

So i'm just trying to adhere to the spreadsheet. Everything is

now correct already but can the excel return empty cell when a

value is met? i just want to know more. =)

re: "can the excel return empty cell when a value is met?"Yes...

=IF(AF37=0,"",AF37)

Put this in H30 then check the Length.

=LEN(H30)

"" will return 0 while your formula (" ") will return 1.

There are other funtions that will return different results for a "" vs. a " " so it really depends on what you are doing with the result.

hmm.. i think i get it!

i will be using the " " for this cell though

thanks so much for willing to spent your precious time explaining

to me. I really appreciate it. Thank you once again =)

Ask Your Question

Weekly Poll

Do you trust smart speakers to not spy on you?

Discuss in The Lounge

Poll History