![]() |
|
|||||||
|
|
|
|
|
|
I have problem with devide by 8, how to make answer in excell
(A1)35, (B1)8, (C1) "Answer 1", (D1) "Answer 2". I want the answer is: "Answer 1" = 4 and "Answer 2" = 3, Because 35-(8*4)=3. :4-dontkno
Thank You:wave:...
|
![]() |
|
|
Thread Tools |
|
#1
|
|||
|
|||
|
I have problem with devide by 8, how to make answer in excell
(A1)35, (B1)8, (C1) "Answer 1", (D1) "Answer 2". I want the answer is: "Answer 1" = 4 and "Answer 2" = 3, Because 35-(8*4)=3. :4-dontkno Thank You:wave: |
|
#2
|
||||||||||||
|
||||||||||||
|
I don't understand what you mean, sorry.
Do you mean: 35-(8*4) is 3 yes, is that all you're trying to work out? I don't see where 4 came into it, or what you're trying to achieve.. EDIT: In D1, if I'm following you right you need to enter: Code:
=SUM(A1-(B1*4)) (If the answer in C1 IS 4, then you can change the formula in D1 to Code:
=SUM(A1-(B1*C1)) Maybe a little more info and I can help you out
__________________
__________________
"Why did they [PS3 Slim] stick with the UFO landing on a rectangle look" --- Nilay Patel; Engadget Ep. 160 My System: FordyPC
|
![]() |
|
| Bookmarks |
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Microsoft Excell sumPRODUCT Problem | texannatl | Office Suites & Applications | 0 | 21st May 2009 23:35 |
| Website Template CMS Based | megabyte | Web Design, Hosting & SEO | 6 | 7th May 2009 07:14 |
| Is open office compatible with microsoft office | pinkypossum001 | Office Suites & Applications | 2 | 21st Nov 2008 08:13 |
| Scsi based controllers | thekuntash | General Hardware Chat | 1 | 8th Nov 2007 11:31 |
| Open office and mirco soft office | ken979 | Office Suites & Applications | 2 | 12th Aug 2007 04:22 |
| Thread Tools | |
|
|