Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
^ Carrot in a Formula
I am unfamiliar with the ^ Character in a formula. What does it mean: Example: =+IF(T$3840,$C416/12*(1+$C$415)^2,0)+IF(U$384=1,$C416/12*(1+$C$415)^2,0)+IF(V$384=1,$C416/12*(1+$C$415)^2,0) Thank you Ross |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
^ Carrot in a Formula
POWER
2^2=4 3^3=9 BTW the leading + in your formula is superfluous, it is a throw-back to Lotus 1-2-3. You can even remove the IFs =(T$3840)*$C416/12*(1+$C$415)^2 + (U$384=1)*$C416/12*(1+$C$415)^2 + (V$384=1)*$C416/12*(1+$C$415)^2 -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Ross" wrote in message ... I am unfamiliar with the ^ Character in a formula. What does it mean: Example: =+IF(T$3840,$C416/12*(1+$C$415)^2,0)+IF(U$384=1,$C416/12*(1+$C$415)^2,0)+IF (V$384=1,$C416/12*(1+$C$415)^2,0) Thank you Ross |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
^ Carrot in a Formula
I think I would have used different numbers in the example <bg:
2^3 = 2*2*2 = 8 3^4 = 3*3*3*3 = 81 Bob Phillips wrote: POWER 2^2=4 3^3=9 BTW the leading + in your formula is superfluous, it is a throw-back to Lotus 1-2-3. You can even remove the IFs =(T$3840)*$C416/12*(1+$C$415)^2 + (U$384=1)*$C416/12*(1+$C$415)^2 + (V$384=1)*$C416/12*(1+$C$415)^2 -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Ross" wrote in message ... I am unfamiliar with the ^ Character in a formula. What does it mean: Example: =+IF(T$3840,$C416/12*(1+$C$415)^2,0)+IF(U$384=1,$C416/12*(1+$C$415)^2,0)+IF (V$384=1,$C416/12*(1+$C$415)^2,0) Thank you Ross -- Dave Peterson |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
^ Carrot in a Formula
This make perfect sense. Thank you Bob!
"Ross" wrote: I am unfamiliar with the ^ Character in a formula. What does it mean: Example: =+IF(T$3840,$C416/12*(1+$C$415)^2,0)+IF(U$384=1,$C416/12*(1+$C$415)^2,0)+IF(V$384=1,$C416/12*(1+$C$415)^2,0) Thank you Ross |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
^ Carrot in a Formula
Three to the third is 27...
Dave -- Brevity is the soul of wit. "Bob Phillips" wrote: POWER 2^2=4 3^3=9 BTW the leading + in your formula is superfluous, it is a throw-back to Lotus 1-2-3. You can even remove the IFs =(T$3840)*$C416/12*(1+$C$415)^2 + (U$384=1)*$C416/12*(1+$C$415)^2 + (V$384=1)*$C416/12*(1+$C$415)^2 -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Ross" wrote in message ... I am unfamiliar with the ^ Character in a formula. What does it mean: Example: =+IF(T$3840,$C416/12*(1+$C$415)^2,0)+IF(U$384=1,$C416/12*(1+$C$415)^2,0)+IF (V$384=1,$C416/12*(1+$C$415)^2,0) Thank you Ross |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
^ Carrot in a Formula
It's actually 1.44225 but I take the point. <G
-Bob "Dave F" wrote in message ... Three to the third is 27... Dave -- Brevity is the soul of wit. "Bob Phillips" wrote: POWER 2^2=4 3^3=9 BTW the leading + in your formula is superfluous, it is a throw-back to Lotus 1-2-3. You can even remove the IFs =(T$3840)*$C416/12*(1+$C$415)^2 + (U$384=1)*$C416/12*(1+$C$415)^2 + (V$384=1)*$C416/12*(1+$C$415)^2 -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Ross" wrote in message ... I am unfamiliar with the ^ Character in a formula. What does it mean: Example: =+IF(T$3840,$C416/12*(1+$C$415)^2,0)+IF(U$384=1,$C416/12*(1+$C$415)^2,0)+IF (V$384=1,$C416/12*(1+$C$415)^2,0) Thank you Ross |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
^ Carrot in a Formula
1.44225??
-- Brevity is the soul of wit. "Bob Phillips" wrote: It's actually 1.44225 but I take the point. <G -Bob "Dave F" wrote in message ... Three to the third is 27... Dave -- Brevity is the soul of wit. "Bob Phillips" wrote: POWER 2^2=4 3^3=9 BTW the leading + in your formula is superfluous, it is a throw-back to Lotus 1-2-3. You can even remove the IFs =(T$3840)*$C416/12*(1+$C$415)^2 + (U$384=1)*$C416/12*(1+$C$415)^2 + (V$384=1)*$C416/12*(1+$C$415)^2 -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Ross" wrote in message ... I am unfamiliar with the ^ Character in a formula. What does it mean: Example: =+IF(T$3840,$C416/12*(1+$C$415)^2,0)+IF(U$384=1,$C416/12*(1+$C$415)^2,0)+IF (V$384=1,$C416/12*(1+$C$415)^2,0) Thank you Ross |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
^ Carrot in a Formula
I think he misunderstood your "three to the third" and translated it as
"three to the one-third" "Dave F" wrote: 1.44225?? -- Brevity is the soul of wit. "Bob Phillips" wrote: It's actually 1.44225 but I take the point. <G -Bob "Dave F" wrote in message ... Three to the third is 27... Dave -- Brevity is the soul of wit. "Bob Phillips" wrote: POWER 2^2=4 3^3=9 BTW the leading + in your formula is superfluous, it is a throw-back to Lotus 1-2-3. You can even remove the IFs =(T$3840)*$C416/12*(1+$C$415)^2 + (U$384=1)*$C416/12*(1+$C$415)^2 + (V$384=1)*$C416/12*(1+$C$415)^2 -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Ross" wrote in message ... I am unfamiliar with the ^ Character in a formula. What does it mean: Example: =+IF(T$3840,$C416/12*(1+$C$415)^2,0)+IF(U$384=1,$C416/12*(1+$C$415)^2,0)+IF (V$384=1,$C416/12*(1+$C$415)^2,0) Thank you Ross |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
^ Carrot in a Formula
Ahhh.
The cube root of 3. Thanks... -- Brevity is the soul of wit. "Duke Carey" wrote: I think he misunderstood your "three to the third" and translated it as "three to the one-third" "Dave F" wrote: 1.44225?? -- Brevity is the soul of wit. "Bob Phillips" wrote: It's actually 1.44225 but I take the point. <G -Bob "Dave F" wrote in message ... Three to the third is 27... Dave -- Brevity is the soul of wit. "Bob Phillips" wrote: POWER 2^2=4 3^3=9 BTW the leading + in your formula is superfluous, it is a throw-back to Lotus 1-2-3. You can even remove the IFs =(T$3840)*$C416/12*(1+$C$415)^2 + (U$384=1)*$C416/12*(1+$C$415)^2 + (V$384=1)*$C416/12*(1+$C$415)^2 -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Ross" wrote in message ... I am unfamiliar with the ^ Character in a formula. What does it mean: Example: =+IF(T$3840,$C416/12*(1+$C$415)^2,0)+IF(U$384=1,$C416/12*(1+$C$415)^2,0)+IF (V$384=1,$C416/12*(1+$C$415)^2,0) Thank you Ross |
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
^ Carrot in a Formula
Caret vs carrot. Just trying to help
-- Don Guillett SalesAid Software "Ross" wrote in message ... I am unfamiliar with the ^ Character in a formula. What does it mean: Example: =+IF(T$3840,$C416/12*(1+$C$415)^2,0)+IF(U$384=1,$C416/12*(1+$C$415)^2,0)+IF(V$384=1,$C416/12*(1+$C$415)^2,0) Thank you Ross |
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
^ Carrot in a Formula
Don't forget carat!
Dave -- Brevity is the soul of wit. "Don Guillett" wrote: Caret vs carrot. Just trying to help -- Don Guillett SalesAid Software "Ross" wrote in message ... I am unfamiliar with the ^ Character in a formula. What does it mean: Example: =+IF(T$3840,$C416/12*(1+$C$415)^2,0)+IF(U$384=1,$C416/12*(1+$C$415)^2,0)+IF(V$384=1,$C416/12*(1+$C$415)^2,0) Thank you Ross |
#12
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
^ Carrot in a Formula
It can only be read that way, third is a fraction or a ordinal number (which
is meaningless in this context, there is no order). -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Duke Carey" wrote in message ... I think he misunderstood your "three to the third" and translated it as "three to the one-third" "Dave F" wrote: 1.44225?? -- Brevity is the soul of wit. "Bob Phillips" wrote: It's actually 1.44225 but I take the point. <G -Bob "Dave F" wrote in message ... Three to the third is 27... Dave -- Brevity is the soul of wit. "Bob Phillips" wrote: POWER 2^2=4 3^3=9 BTW the leading + in your formula is superfluous, it is a throw-back to Lotus 1-2-3. You can even remove the IFs =(T$3840)*$C416/12*(1+$C$415)^2 + (U$384=1)*$C416/12*(1+$C$415)^2 + (V$384=1)*$C416/12*(1+$C$415)^2 -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Ross" wrote in message ... I am unfamiliar with the ^ Character in a formula. What does it mean: Example: =+IF(T$3840,$C416/12*(1+$C$415)^2,0)+IF(U$384=1,$C416/12*(1+$C$415)^2,0)+IF (V$384=1,$C416/12*(1+$C$415)^2,0) Thank you Ross |
#13
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
^ Carrot in a Formula
Which reminds me:
Which is correct? 1. eight and eight _IS_ 17 or 2. eight and eight _ARE_ 17 The capital of Kentucky is pronounced: 1. Loo-is-vill or 2. Loo-ee-vill ..Scroll down for answers .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. 8+8=16 (not 17) Frankfort (not Louisville) Dave F wrote: Three to the third is 27... Dave -- Brevity is the soul of wit. "Bob Phillips" wrote: POWER 2^2=4 3^3=9 BTW the leading + in your formula is superfluous, it is a throw-back to Lotus 1-2-3. You can even remove the IFs =(T$3840)*$C416/12*(1+$C$415)^2 + (U$384=1)*$C416/12*(1+$C$415)^2 + (V$384=1)*$C416/12*(1+$C$415)^2 -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Ross" wrote in message ... I am unfamiliar with the ^ Character in a formula. What does it mean: Example: =+IF(T$3840,$C416/12*(1+$C$415)^2,0)+IF(U$384=1,$C416/12*(1+$C$415)^2,0)+IF (V$384=1,$C416/12*(1+$C$415)^2,0) Thank you Ross -- Dave Peterson |
#14
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
^ Carrot in a Formula
The ordinal is being used to indicate the power. Two to the fifth is the
fifth power of two (= 2^5). -- David Biddulph "Bob Phillips" wrote in message ... It can only be read that way, third is a fraction or a ordinal number (which is meaningless in this context, there is no order). -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Duke Carey" wrote in message ... I think he misunderstood your "three to the third" and translated it as "three to the one-third" "Dave F" wrote: 1.44225?? -- Brevity is the soul of wit. "Bob Phillips" wrote: It's actually 1.44225 but I take the point. <G -Bob "Dave F" wrote in message ... Three to the third is 27... Dave -- Brevity is the soul of wit. "Bob Phillips" wrote: POWER 2^2=4 3^3=9 BTW the leading + in your formula is superfluous, it is a throw-back to Lotus 1-2-3. You can even remove the IFs =(T$3840)*$C416/12*(1+$C$415)^2 + (U$384=1)*$C416/12*(1+$C$415)^2 + (V$384=1)*$C416/12*(1+$C$415)^2 -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Ross" wrote in message ... I am unfamiliar with the ^ Character in a formula. What does it mean: Example: =+IF(T$3840,$C416/12*(1+$C$415)^2,0)+IF(U$384=1,$C416/12*(1+$C$415)^2,0)+IF (V$384=1,$C416/12*(1+$C$415)^2,0) Thank you Ross |
#15
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
^ Carrot in a Formula
Reminds me of my late daddy.
Which is correct? the pigs is so or the pigs are so If you gave him the correct answer he would laugh like hell. I miss him. Gord On Thu, 09 Nov 2006 12:06:54 -0600, Dave Peterson wrote: Which reminds me: Which is correct? 1. eight and eight _IS_ 17 or 2. eight and eight _ARE_ 17 The capital of Kentucky is pronounced: 1. Loo-is-vill or 2. Loo-ee-vill .Scroll down for answers . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8+8=16 (not 17) Frankfort (not Louisville) Dave F wrote: Three to the third is 27... Dave -- Brevity is the soul of wit. "Bob Phillips" wrote: POWER 2^2=4 3^3=9 BTW the leading + in your formula is superfluous, it is a throw-back to Lotus 1-2-3. You can even remove the IFs =(T$3840)*$C416/12*(1+$C$415)^2 + (U$384=1)*$C416/12*(1+$C$415)^2 + (V$384=1)*$C416/12*(1+$C$415)^2 -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Ross" wrote in message ... I am unfamiliar with the ^ Character in a formula. What does it mean: Example: =+IF(T$3840,$C416/12*(1+$C$415)^2,0)+IF(U$384=1,$C416/12*(1+$C$415)^2,0)+IF (V$384=1,$C416/12*(1+$C$415)^2,0) Thank you Ross Gord Dibben MS Excel MVP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reusing formula | Excel Discussion (Misc queries) | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |