It has me stumped. if(c10=0,"",=sumC8:C10) I have tried various alternates including nested ifs, no =, sumif and additional parentheses to no avail. Sorry to join the group and jump right in with a request for help that probably makes me look pretty silly, but I do have some things to offer. Thanks in advance.
by C10=0 I mean contains no data. It is formatted for currency.
Last edited by Teeay5324; 06-03-2017 at 10:37 AM. Reason: Improper Title
Welcome to the forum...
Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem.
Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
Thank you for the correction and sorry for unintentionally disobeying the forum rules. It will be corrected post-haste.
As soon as I saw your response, I saw my problem. I did indeed try that exact syntax, with one major flaw - no "=" to begin the formula. Problem solved, thank you.
Thank you for the update.
Does
=IF(C10=0,"",SUM(C8:C10))
not work for you?
I appreciate you mentioned 'no =' but perhaps something else was wrong with the syntax. If that formula does not work then upload a sample workbook.
As soon as I saw your response, I saw my problem. I did indeed try that exact syntax, with one major flaw - no "=" to begin the formula. Problem solved, thank you.Originally Posted by cytop
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
That was going to be my next question. Well moderated forum here, thanks for everything.
Hi Teeay and welcome to the forum,
You need to edit your first post and go to advanced and edit the thread title to something like:
What is the difference between C10= 0 and C10 = ""?
That might be a much better thread title so we could find it in the future. (I also hope it answers your question.)
Perhaps you want
If(Len(C10)=0, , )
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Thank you for your advice.
if the solution offered above doesn't work....
Will you please attach a SMALL sample Excel workbook (10-20 rows of data is usually enough)? Please don't attach a picture of one (no-one will want to re-type all your stuff before starting).
1. Make sure that your sample data are truly REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.
2. Make sure that your desired solution is also shown (mock up the results manually).
3. Make sure that all confidential information is removed first!!
4. Try to avoid using merged cells. They cause lots of problems!
Unfortunately the attachment icon doesn't work at the moment. So, to attach an Excel file you have to do the following: Just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Thank you for the information, I will keep it in mind for future posts.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks