Hi I am new to the forum
I want to calculate (A2-A1)/56
sometimes A1 is blank and sometimes A2 is blank if this is the case then I want the formula to ignore that row and give me a blank rather than give me a value.
I tried using an IF and an OR but I keep getting an error message and I'm not sure where I am going wrong
any help with this would be greatly appreciated
Thanks
Last edited by unicorn; 06-15-2011 at 07:38 AM.
Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. 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 on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
PLEASE PM WHEN YOU HAVE DONE THIS AND I WILL DELETE THIS POST
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
Aside with complying with what NBVC says I don't see what you're issue is.
I put that formula in and with blank cells I returned a nil value.
A little more detail or a spreadsheet containing dummy data similar to what you're dealing with would be extremely helpful.
Looks like this got answered here
...so thread closed
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Bookmarks