|
|
#1
01-09-2017, 04:58 PM
|
|||
|
|||
Formula Problem
I am trying to create a formula that will take a cell (c58) minus other cells (c59 to c63) and round it to an even number in cell c64
Any help would be greatly appreciated. Cheers 
|
|
#2
01-09-2017, 05:03 PM
|
|||
|
|||
|
So if you subtract C58 from the Sum of C59:C63 and the result is -23, what is the answer?
Do you have sample data and results you would expect? We can probably create many different formulas, but without knowing your exact variable we are guessing at certain points.
|
|
#3
01-09-2017, 05:13 PM
|
|||
|
|||
|
cell c58 has $1590
cell c59:C63 add up to $600 The answer I am looking for is $990
|
|
#4
01-09-2017, 05:16 PM
|
|||
|
|||
|
What does this give you?
=C58-SUM(C59:C63)
|
|
#5
01-09-2017, 05:18 PM
|
|||
|
|||
|
That gives me the answer I am looking for. Is there a way to tell it to round the formula?
|
|
#6
01-09-2017, 05:24 PM
|
|||
|
|||
|
Yes, how about...
=ROUNDUP(C58-SUM(C59:C63),0)
|
|
#7
01-09-2017, 05:28 PM
|
|||
|
|||
|
It worked! Thank you so much.
|
|
#8
01-09-2017, 05:30 PM
|
|||
|
|||
|
You are very welcome. Thanks for the feedback.
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Excel formula problem/ Help required
|
dmcg9760 | Excel | 5 | 09-10-2015 09:42 PM |
|
Formula Problem
|
pikerman | Excel | 2 | 02-16-2015 01:38 AM |
|
Problem with formula!
|
Victoria Linen | Excel | 1 | 02-04-2014 01:10 PM |
|
Embedded IF AND OR Formula Problem
|
J Morrow | Excel | 9 | 08-26-2011 06:51 AM |
| Formula problem? | markg2 | Excel | 11 | 06-10-2010 07:42 AM |
Mac OS X 
Office for Mac 2011
Linear Mode
