|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
#6
July 13th 07, 12:50 AM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
help on a Formula
or turn it around as :
=sum(a1:a3)*1.2 both will work -- smither fan "legend query" wrote: U can do this way.... =120%*(sum(a1:a3)) "Shanny" wrote: I have a colleague that asked help with a formula - He would like to add 3 cells up and then multiply it by 20% and add that into the total I tried =sum(a1:a3)+(a1:a3*.20) but it didn't work Can this be done in one cell or do you have to use two cells to calculate this. thanks Shanny 
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| If Then Formula | Aggie G | Outlook - Using Forms | 5 | November 8th 06 07:16 PM |
| Need a formula | Charles Woll | Outlook Express | 2 | February 26th 06 08:27 PM |
| Reference Formula | ~KO | Outlook - Using Forms | 3 | February 24th 06 09:20 PM |
| Creating a validation formula | Sue Mosher [MVP-Outlook] | Outlook - Using Forms | 0 | January 20th 06 06:26 PM |
| New Field Formula editor | Sue Mosher [MVP-Outlook] | Outlook - Using Contacts | 0 | January 18th 06 06:10 PM |
Threaded Mode