Home |
Search |
Today's Posts |
#1
|
|||
|
|||
using a function based on the value of a function
Can anyone provide instruction on how to make a secondary function (in a
separate column) look up the value (result) of the first function without having to paste the values. Thanks in advance! |
#2
|
|||
|
|||
Hi Judy,
Not sure if I follow. But maybe you can use an IF function ... =IF(A1=4,"A1 equals 4","") This says that if the value (formula result) of A1 equals a numeric value of 4, then have this formula return the text "A1 equals 4"; and if it doesn't, then return a null string ( "" ). Does this help? -- Regards, Zack Barresse, aka firefytr "Judy" wrote in message ... Can anyone provide instruction on how to make a secondary function (in a separate column) look up the value (result) of the first function without having to paste the values. Thanks in advance! |
#3
|
|||
|
|||
Example
A1:17 B1:=A1*2 C1:=IF(B130,"30","<30") is that what you mean? -- HTH RP (remove nothere from the email address if mailing direct) "Judy" wrote in message ... Can anyone provide instruction on how to make a secondary function (in a separate column) look up the value (result) of the first function without having to paste the values. Thanks in advance! |
#4
|
|||
|
|||
thanks to Bob and Zack -
now, I've got a long if statement, but it's not working perfectly yet. Do I need to have ampersands or quotes anywhere that I missed? Do I have my less than/greater than/equal signs mixed up? =IF(G4<=0.249,"A",(IF(G4=0.25<=0.399,"B",(IF(G4= 0.4<=0.499,"C",(IF(G4=0.5<=0.599,"D",(IF(G4=0.6< =0.849,"E",(IF(G4=0.85<=1.749,"F",(IF(G4=1.75<=3 .149,"G",(IF(G4=3.15<=99.999,"H","")))))))))))))) ) I'm trying to have this cell compute a letter (A thru H) based on ranges. Thanks! "Bob Phillips" wrote: Example A1:17 B1:=A1*2 C1:=IF(B130,"30","<30") is that what you mean? -- HTH RP (remove nothere from the email address if mailing direct) "Judy" wrote in message ... Can anyone provide instruction on how to make a secondary function (in a separate column) look up the value (result) of the first function without having to paste the values. Thanks in advance! |
#5
|
|||
|
|||
Judy,
If comparing two values, you need AND, such as G4=0.25<=0.399 should be AND(G4=0.25,G4<=0.399) but in this case the previous test precludes re-testing the first part, so all you need is =IF(G4<=0.249,"A",(IF(G4<=0.399,"B",(IF(G4<=0.499, "C",(IF(G4<=0.599,"D",(IF( G4<=0.849,"E",(IF(G4<=1.749,"F",(IF(G4<=3.149,"G", (IF(G4<=99.999,"H",""))))) )))))))))) -- HTH RP (remove nothere from the email address if mailing direct) "Judy" wrote in message ... thanks to Bob and Zack - now, I've got a long if statement, but it's not working perfectly yet. Do I need to have ampersands or quotes anywhere that I missed? Do I have my less than/greater than/equal signs mixed up? =IF(G4<=0.249,"A",(IF(G4=0.25<=0.399,"B",(IF(G4= 0.4<=0.499,"C",(IF(G4=0.5 <=0.599,"D",(IF(G4=0.6<=0.849,"E",(IF(G4=0.85<=1 .749,"F",(IF(G4=1.75<=3.1 49,"G",(IF(G4=3.15<=99.999,"H",""))))))))))))))) I'm trying to have this cell compute a letter (A thru H) based on ranges. Thanks! "Bob Phillips" wrote: Example A1:17 B1:=A1*2 C1:=IF(B130,"30","<30") is that what you mean? -- HTH RP (remove nothere from the email address if mailing direct) "Judy" wrote in message ... Can anyone provide instruction on how to make a secondary function (in a separate column) look up the value (result) of the first function without having to paste the values. Thanks in advance! |
#6
|
|||
|
|||
You could also accumulate that into only 1 or 2 IF functions ...
=IF(G40.25,IF(G4=100,"Over",LOOKUP(G4,{0.25,"B"; 0.4,"C";0.5,"D";0.6,"E";0.85,"F";1.75,"G";3.15,"H" })),"A") The only reason you'd need the IF's are to deal with high or low values. HTH -- Regards, Zack Barresse, aka firefytr "Bob Phillips" wrote in message ... Judy, If comparing two values, you need AND, such as G4=0.25<=0.399 should be AND(G4=0.25,G4<=0.399) but in this case the previous test precludes re-testing the first part, so all you need is =IF(G4<=0.249,"A",(IF(G4<=0.399,"B",(IF(G4<=0.499, "C",(IF(G4<=0.599,"D",(IF( G4<=0.849,"E",(IF(G4<=1.749,"F",(IF(G4<=3.149,"G", (IF(G4<=99.999,"H",""))))) )))))))))) -- HTH RP (remove nothere from the email address if mailing direct) "Judy" wrote in message ... thanks to Bob and Zack - now, I've got a long if statement, but it's not working perfectly yet. Do I need to have ampersands or quotes anywhere that I missed? Do I have my less than/greater than/equal signs mixed up? =IF(G4<=0.249,"A",(IF(G4=0.25<=0.399,"B",(IF(G4= 0.4<=0.499,"C",(IF(G4=0.5 <=0.599,"D",(IF(G4=0.6<=0.849,"E",(IF(G4=0.85<=1 .749,"F",(IF(G4=1.75<=3.1 49,"G",(IF(G4=3.15<=99.999,"H",""))))))))))))))) I'm trying to have this cell compute a letter (A thru H) based on ranges. Thanks! "Bob Phillips" wrote: Example A1:17 B1:=A1*2 C1:=IF(B130,"30","<30") is that what you mean? -- HTH RP (remove nothere from the email address if mailing direct) "Judy" wrote in message ... Can anyone provide instruction on how to make a secondary function (in a separate column) look up the value (result) of the first function without having to paste the values. Thanks in advance! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
clock | Excel Worksheet Functions | |||
function based on result of same function | Excel Discussion (Misc queries) | |||
Can I count in an array based on a function? | Excel Worksheet Functions | |||
Is it possible to use the sumif function based on the criteria of. | Excel Worksheet Functions | |||
I need a function to update sales/expenses based on previous tota. | Excel Worksheet Functions |