Ask Your Question

The If function =If(C11<1,0,F10-D11+E11) gives me a blank cell if C11 is empty and 000.00 if it is blank in another spreadsheet WHY

asked 2018-03-19 16:06:26 +0200

lkellis gravatar image

The purpose is to not have 000.00 for the ck book balance if a transaction date is no entered

edit retag flag offensive close merge delete


Please consider to read this thread concerning the parameter delimiter.

Lupp gravatar imageLupp ( 2018-03-19 16:43:14 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2018-03-19 16:40:55 +0200

Lupp gravatar image

updated 2018-03-19 16:42:20 +0200

-1- A formula result cannot be exactly blank. If nothing is shown the reult may be
-1.1- empty or whitespace text. (This, however, not with your arithmetic expressions.)
-1-2- zero in a document for which suppression of zero results was set (Not recommended!)
-1-3- anything in a cell for which an extremely lying 'Numbers' format is set.
-2- If 000.00 is shown for a zero result there must be set a non-default cell style or 'Numebers' format for the cell.
-2-1- Common default cell style Using 'General' format for numbers would display 0 (except with case -1-2-).
-2-2- A different setting should be intentionally applied. "Who did?" is then the question.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-03-19 16:06:26 +0200

Seen: 46 times

Last updated: Mar 19 '18