Need to show blank, but in Googel Sheets it must show 0.00 =IF(OR(C7="",F7<>""),"",C6-C7

I have this formula that is working =IF(OR(C7="",F7<>""),"",C6-C7)
but now the program i using to get data from google sheet needs to show 0.00 to work.
But when I put in 0.00 all my data is then not working


How can I make this to work to let the program see 0.00 ,but still show blank on google sheets

Once again, you have posted in the wrong section - Google Sheets queries go under Other Platforms ...

I have moved the thread for you.

Have you tried this?

=IF(OR(C7="",F7<>""),0,C6-C7)

I am struggling to visualise what the issue actually is here.

You'll have to post a link, but's it no use unless you show us manually what you want.

You need to make the sheet publicly available. At the moment it's asking me to request access, and I'm sorry, but I am not prepared to share my E-mail address for that to happen.

How about using the formula with 0, but conditionally formatting the column to show zero values as white text? This wwould mean that the 0 is there, but it won't show on your worksheet. I don't know how conditional formating works in Google Sheets, though.

The one in post #3.

Try changing it to this:

=IF(OR(C4="",F4>0),"",C3-C4)

OK. And are you happy with the conditional formatting? It's under Format on Google Sheets: https://support.google.com/docs/answ...ppy=%2Cexample

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.