• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

solved! Need formula in excel to display blank instead of 0

gorcorps

gorcorps

aka Brandon
I have this if statement that's filtering out certain numbers, and I currently have it set up so that if it doesn't meet my criteria it SHOULD give me a blank box. But it's filling in a zero automatically. I need to average this column so I can't have the zeros there to throw things off. I've tried putting a space as the output, or linking to an already blank box and both return zeros.

Is there a way to either make it blank or to average something while ignoring zeroes?

Excel 2003

solved: I'm simply a fool
 
Last edited:
Couldn't you have it place an alpha character instead of a number? That way it wouldn't dick up the averages.
 
Ah, I think I see what you mean lxskllr. If I output "CHAR(1)" it outputs a space, which gives me the blank spots I needed. Everything looks to be working out properly, thanks!
 
I don't really work with spreadsheets, but it seems to me the alpha character would be an easy workaround. Use a logic clause, and if it doesn't match the argument, insert an "N". Then when the math gets done, it should ignore the alpha character, or if it doesn't, add a statement to ignore alpha characters.

Sorry I can't give you specifics. I used to do a lot of calculator programming, but I've never worked with spreadsheets. I should have, but I never had an immediate need, and I have a hard time teaching myself stuff without needing it right away.
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top