![]() |
|
|
Thread Tools | Display Modes |
#6
|
||||
|
||||
![]()
Ask yourself how you would do it without the text part.
What are you trying to do ? Round the result to two decimals. Did I say ROUND ? OK then let's use the ROUND function =ROUND(sum(your_range),2) Now use this new formula the same way we used SUM alone before... I trust you now have the answer ![]()
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
iuliandonici | Excel | 1 | 04-13-2011 09:45 PM |
![]() |
iuliandonici | Excel | 4 | 04-13-2011 09:27 PM |
![]() |
Learner7 | Excel | 1 | 03-22-2011 02:35 PM |
![]() |
Learner7 | Excel | 1 | 07-19-2010 10:06 AM |
Pasting multiple photos - one photo per cell in a single oepration | mccruise | Word | 0 | 04-07-2010 04:13 AM |