Problem with a formula

[metsmaniac]

I can't get this formula to return value 99 if cell C10 is blank:
=IF(AND(B10="H",C10=0),"99",C10)

I've tried this:
=IF(AND(B10="H",C10=""),"99",C10)

and this:
=IF(AND(B10="H",trim(C10=0)),"99",C10)

The formula only returns the contents of C10 if C10 is populated, but it doesn't return value 99 if it's blank.

Can anyone help?

 

[Fluff]

What does it return?
Also is there anything in C10, such as a formula?

 

[Scott T]

What is in C10? Is it a formula that returns blank or is it really blank?

 

[Marcelo Branco]

Maybe...

=IF(AND(TRIM(B10)="H",C10=""),"99",C10)

M.

 

[metsmaniac]

C10 is blank.
I ran an Access 2013 query and pasted the "text results only" into an Excel spreadsheet.
The formula returns whatever value is in C10, so if C10 is blank, it returns blank.
I tried running the 'text to value' formula on C10. No luck.

 

[Fluff]

Put this in an empty cell, what does it return
=code(C10)

 

[metsmaniac]

It returns value 32.

 

[Fluff]

In that case it contains a space, try
=IF(AND(B10="H",len(trim(C10))=0),"99",C10)

 

[metsmaniac]

That worked! Thank you!

 

[Fluff]

You're welcome & thanks for the feedback