| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Maths
If,
1=5 2=25 3=325 4=4325 5=? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Maths
54325
"Mohamed Rifan" wrote: If, 1=5 2=25 3=325 4=4325 5=? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Maths
It looks like your answer should be:
54325 With 5 in A1 and 25 in A2, put this formula in A3: =(INT(A2/10^ROW(A1))+1)*10^(ROW(A1)+1)+A2 and copy down. Hope this helps. Pete On Apr 24, 11:16*am, Mohamed Rifan <Mohamed wrote: If, 1=5 2=25 3=325 4=4325 5=? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Maths
I hope it took you guys longer than just a minute to come up with that
answer... "Mohamed Rifan" wrote: If, 1=5 2=25 3=325 4=4325 5=? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Maths
Hi. Not sure what the rule is for n10, but perhaps the equation can be
reduced for n <= 10 Place in A1, and copy down to A10. =(10^ROW()*(9*ROW() - 1) + 325)/81 HTH Dana DeLouis = = = = = Mohamed Rifan wrote: If, 1=5 2=25 3=325 4=4325 5=? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maths In Excel - Help Needed! | Excel Discussion (Misc queries) | |||
| maths expression antilog10 | Excel Discussion (Misc queries) | |||
| Maths Fonts | Excel Discussion (Misc queries) | |||
| Maths Fonts | Excel Discussion (Misc queries) | |||
| result is Zero on every maths functions - sum, multiplication ... etc | Excel Worksheet Functions | |||
Linear Mode
