Hi all, this is the first time I've used this forum, so please bear with me while I try to explain what I need.
What I want is a formula for B1 and B2 which is 50% of A1 and A2 and if the value of A1 is not divisible by 2, but A2 is divisible by 2, then both B1 and B2 round up and vice versa. However, if neither A1 nor A2 are divisible by 2, i need B1 to round down and B2 to round up. Is this possible? I hope I've explained it clearly. Please see attachment. Thanks in advance for any advice.
Last edited by nicolam_83; 02-16-2016 at 05:35 PM.
Doesn't sound complicated but I still don't see expected result from your example. Don't even know what is in A1, A2... And do you take in C column from B column or A column.
Never use Merged Cells in Excel
I'm sorry, I have edited my post to hopefully make it clearer. Thanks.
I don't quite follow your explanation, but I think it will look something like:
Please Login or Register to view this content.
Last edited by protonLeah; 02-16-2016 at 08:31 PM.
Ben Van Johnson
What if both are divisible by 2?
Quang PT
protonLeah, thank you for your reply. I have tried your formula and an error comes up saying - A value used in the formula is of the wrong data type?
bebo021999 - if they are both divisible by two, that's fine, I am only struggling for this formula if none of them are divisible by 2.
Thank you.
protonLeah, thank you for your reply. I have tried your formula and an error comes up saying - A value used in the formula is of the wrong data type?
bebo021999 - if they are both divisible by two, that's fine, I am only struggling for this formula if none of them are divisible by 2.
Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks