LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 143
Default if function shows 0 instead of blank

Hello this is my formula =IF(F38=" "," ",IF(F38="YES",C25,FALSE))
I do not get the result I want. If F 38 is blank it shows a 0 .I
do not want the zero I want it to be blank thanks


Though it looks the same, a cell with a "space" character in it is
different from a cell that's empty. Your formula is testing for one
"space" character only.

Also, if C25 is empty, the formula returns returns zero in the "YES" case.

To allow for unseen spaces in general, and to allow for C25="", you might
consider something like:
=IF(TRIM(F38)="","",IF(TRIM(F38)="YES",IF(TRIM(C25 )="","",C25),FALSE))

The TRIM function is described in Excel's built-in Help.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
blank date shows up as s 1/0/00 Mary Excel Worksheet Functions 2 July 17th 08 12:00 AM
Shows blank worksheet but ok in print preview Big Mac Excel Discussion (Misc queries) 1 November 14th 06 02:36 PM
function results shows 0 deroline Excel Worksheet Functions 3 October 5th 06 04:15 PM
My Excel 2000 shows 97 worksheets grey-blank - help!? MG-Trophy Excel Discussion (Misc queries) 2 December 21st 05 12:30 AM
blank data field shows quote in formula, how to delete it? wdanner Excel Discussion (Misc queries) 2 April 4th 05 08:44 PM


All times are GMT +1. The time now is 02:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"