Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ISNUMBER
In cell K2, I wish to have the appropriate "Text LabeL" depending on J2 being
greater than or less than F2 but only if a value has been entered into J2 and F2. I would not want any value in K2 if no values are entered into J2 and F2. This is what I am attempting but not working. Any suggestions? =IF(AND(ISNUMBER(F2), ISNUMBER(J2)),J2F2,"Text Label A","Text Label B") |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ISNUMBER
=IF(COUNT(F2,J2),IF(J2F2,"Text Label A","Text Label B"),"")
RJJ wrote: In cell K2, I wish to have the appropriate "Text LabeL" depending on J2 being greater than or less than F2 but only if a value has been entered into J2 and F2. I would not want any value in K2 if no values are entered into J2 and F2. This is what I am attempting but not working. Any suggestions? =IF(AND(ISNUMBER(F2), ISNUMBER(J2)),J2F2,"Text Label A","Text Label B") |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ISNUMBER
In what way is your formula not working? Does F2 and J2 contain formulae?
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "RJJ" wrote in message ... In cell K2, I wish to have the appropriate "Text LabeL" depending on J2 being greater than or less than F2 but only if a value has been entered into J2 and F2. I would not want any value in K2 if no values are entered into J2 and F2. This is what I am attempting but not working. Any suggestions? =IF(AND(ISNUMBER(F2), ISNUMBER(J2)),J2F2,"Text Label A","Text Label B") |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ISNUMBER
Yes they do. My error message states "You've entered too many arguements for
this function". But remember, I don't want any text in cell K2 if no numbers are entered in F2 and J2. I intend to copy down this formula. "Bob Phillips" wrote: In what way is your formula not working? Does F2 and J2 contain formulae? -- HTH Bob Phillips (remove nothere from email address if mailing direct) "RJJ" wrote in message ... In cell K2, I wish to have the appropriate "Text LabeL" depending on J2 being greater than or less than F2 but only if a value has been entered into J2 and F2. I would not want any value in K2 if no values are entered into J2 and F2. This is what I am attempting but not working. Any suggestions? =IF(AND(ISNUMBER(F2), ISNUMBER(J2)),J2F2,"Text Label A","Text Label B") |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ISNUMBER
I've tried your suggestion but, the text label changes accordingly with
regards to greater than or less than however a text label is present in K2 even if no numbers are entered in J2 & F2. "Aladin Akyurek" wrote: =IF(COUNT(F2,J2),IF(J2F2,"Text Label A","Text Label B"),"") RJJ wrote: In cell K2, I wish to have the appropriate "Text LabeL" depending on J2 being greater than or less than F2 but only if a value has been entered into J2 and F2. I would not want any value in K2 if no values are entered into J2 and F2. This is what I am attempting but not working. Any suggestions? =IF(AND(ISNUMBER(F2), ISNUMBER(J2)),J2F2,"Text Label A","Text Label B") |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ISNUMBER
Try this
=IF(AND(ISNUMBER(F2), ISNUMBER(J2)),IF(J2F2,"Text Label A","Text Label B"),"") -- HTH Bob Phillips (remove nothere from email address if mailing direct) "RJJ" wrote in message ... Yes they do. My error message states "You've entered too many arguements for this function". But remember, I don't want any text in cell K2 if no numbers are entered in F2 and J2. I intend to copy down this formula. "Bob Phillips" wrote: In what way is your formula not working? Does F2 and J2 contain formulae? -- HTH Bob Phillips (remove nothere from email address if mailing direct) "RJJ" wrote in message ... In cell K2, I wish to have the appropriate "Text LabeL" depending on J2 being greater than or less than F2 but only if a value has been entered into J2 and F2. I would not want any value in K2 if no values are entered into J2 and F2. This is what I am attempting but not working. Any suggestions? =IF(AND(ISNUMBER(F2), ISNUMBER(J2)),J2F2,"Text Label A","Text Label B") |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ISNUMBER
Close. The text label changes accordingly but am still having text show up in
K2 even though there are no numbers entered in F2 and J2. Could it be because J2 and F2 are results of another arguement? In other words, F2=D2*E2 and J2=D2*I2. So when I say nothing is in F2 or J2, what is really happening is that there is nothing entered into D2, E2, or I2. However, a formula resides in F2 and J2 with a "zero" value. Zero values are hidden in tools/options. "Bob Phillips" wrote: Try this =IF(AND(ISNUMBER(F2), ISNUMBER(J2)),IF(J2F2,"Text Label A","Text Label B"),"") -- HTH Bob Phillips (remove nothere from email address if mailing direct) "RJJ" wrote in message ... Yes they do. My error message states "You've entered too many arguements for this function". But remember, I don't want any text in cell K2 if no numbers are entered in F2 and J2. I intend to copy down this formula. "Bob Phillips" wrote: In what way is your formula not working? Does F2 and J2 contain formulae? -- HTH Bob Phillips (remove nothere from email address if mailing direct) "RJJ" wrote in message ... In cell K2, I wish to have the appropriate "Text LabeL" depending on J2 being greater than or less than F2 but only if a value has been entered into J2 and F2. I would not want any value in K2 if no values are entered into J2 and F2. This is what I am attempting but not working. Any suggestions? =IF(AND(ISNUMBER(F2), ISNUMBER(J2)),J2F2,"Text Label A","Text Label B") |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ISNUMBER
Got it. This is was worked.
=IF(AND(F20, J20),IF(J2F2,"Text Label 1","Text Label 2"),"") Thanks so much for all your help. "RJJ" wrote: Close. The text label changes accordingly but am still having text show up in K2 even though there are no numbers entered in F2 and J2. Could it be because J2 and F2 are results of another arguement? In other words, F2=D2*E2 and J2=D2*I2. So when I say nothing is in F2 or J2, what is really happening is that there is nothing entered into D2, E2, or I2. However, a formula resides in F2 and J2 with a "zero" value. Zero values are hidden in tools/options. "Bob Phillips" wrote: Try this =IF(AND(ISNUMBER(F2), ISNUMBER(J2)),IF(J2F2,"Text Label A","Text Label B"),"") -- HTH Bob Phillips (remove nothere from email address if mailing direct) "RJJ" wrote in message ... Yes they do. My error message states "You've entered too many arguements for this function". But remember, I don't want any text in cell K2 if no numbers are entered in F2 and J2. I intend to copy down this formula. "Bob Phillips" wrote: In what way is your formula not working? Does F2 and J2 contain formulae? -- HTH Bob Phillips (remove nothere from email address if mailing direct) "RJJ" wrote in message ... In cell K2, I wish to have the appropriate "Text LabeL" depending on J2 being greater than or less than F2 but only if a value has been entered into J2 and F2. I would not want any value in K2 if no values are entered into J2 and F2. This is what I am attempting but not working. Any suggestions? =IF(AND(ISNUMBER(F2), ISNUMBER(J2)),J2F2,"Text Label A","Text Label B") |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ISNUMBER
Sorry, I meant to say:
=IF(COUNT(F2,J2)=2,IF(J2F2,"Text Label A","Text Label B"),"") But this will consider also real 0's in F2 and J2 as a hit. RJJ wrote: I've tried your suggestion but, the text label changes accordingly with regards to greater than or less than however a text label is present in K2 even if no numbers are entered in J2 & F2. "Aladin Akyurek" wrote: =IF(COUNT(F2,J2),IF(J2F2,"Text Label A","Text Label B"),"") RJJ wrote: In cell K2, I wish to have the appropriate "Text LabeL" depending on J2 being greater than or less than F2 but only if a value has been entered into J2 and F2. I would not want any value in K2 if no values are entered into J2 and F2. This is what I am attempting but not working. Any suggestions? =IF(AND(ISNUMBER(F2), ISNUMBER(J2)),J2F2,"Text Label A","Text Label B") |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ISNUMBER and VLOOKUP Help Needed | Excel Worksheet Functions | |||
Figuring hours | Excel Worksheet Functions | |||
Problem with Array Formulas and ISNUMBER | Excel Worksheet Functions | |||
array functions and ISNUMBER() | Excel Worksheet Functions | |||
isnumber with sumproduct | Excel Worksheet Functions |