Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with formula
=OR($F$1=5,$O$1=5000)The problem with this formula working is the formula in
cell F1 is being read as text (I think) and I need it to read as numerac. Example: The cells that I need are selected and conditional formatted to change to red if these criteria are met. If a 5 is in cell F1 or 5000 in cell O1, The O1 cell works fine because it is a mumeric value but cell F1 has =DATEDIF(A40,TODAY(),"M")&" months " which renders it not working. Any suggestion as to reading F1 as a numeric value without changing this formula in cell F1. Thanks in Advance |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with formula
Richard,
you could try this variation in your CF formula: =OR(LEFT($F$1,1)="5",$O$1=5000) Hope this helps. Pete Richard wrote: =OR($F$1=5,$O$1=5000)The problem with this formula working is the formula in cell F1 is being read as text (I think) and I need it to read as numerac. Example: The cells that I need are selected and conditional formatted to change to red if these criteria are met. If a 5 is in cell F1 or 5000 in cell O1, The O1 cell works fine because it is a mumeric value but cell F1 has =DATEDIF(A40,TODAY(),"M")&" months " which renders it not working. Any suggestion as to reading F1 as a numeric value without changing this formula in cell F1. Thanks in Advance |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with formula
The problem with the formula, as given, is that it is a fragment of a logical
construction. Your sentence says "F1 = 5 OR O1 = 5000" and then does nothing with that logical function. It would be like saying "apples or potatoes" with no other context. What are you trying to test with the OR condition? Dave -- Brevity is the soul of wit. "Richard" wrote: =OR($F$1=5,$O$1=5000)The problem with this formula working is the formula in cell F1 is being read as text (I think) and I need it to read as numerac. Example: The cells that I need are selected and conditional formatted to change to red if these criteria are met. If a 5 is in cell F1 or 5000 in cell O1, The O1 cell works fine because it is a mumeric value but cell F1 has =DATEDIF(A40,TODAY(),"M")&" months " which renders it not working. Any suggestion as to reading F1 as a numeric value without changing this formula in cell F1. Thanks in Advance |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with formula
Look up IS functions in Excel Help, there's an ISNUMBER or an ISTEXT, as well
as other "IS" functions that you can use to evaluate the return value of the formula in cell F1 -- Kevin Backmann "Richard" wrote: =OR($F$1=5,$O$1=5000)The problem with this formula working is the formula in cell F1 is being read as text (I think) and I need it to read as numerac. Example: The cells that I need are selected and conditional formatted to change to red if these criteria are met. If a 5 is in cell F1 or 5000 in cell O1, The O1 cell works fine because it is a mumeric value but cell F1 has =DATEDIF(A40,TODAY(),"M")&" months " which renders it not working. Any suggestion as to reading F1 as a numeric value without changing this formula in cell F1. Thanks in Advance |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with formula
No, it's not a fragment, If these one or both conditions are met ( 1 or 5000)
then under my conditional formatting which ever cells I have selected with change to whichever color that I have selected. Thanks for your help but Kevin and Pete has answered my question. "Dave F" wrote: The problem with the formula, as given, is that it is a fragment of a logical construction. Your sentence says "F1 = 5 OR O1 = 5000" and then does nothing with that logical function. It would be like saying "apples or potatoes" with no other context. What are you trying to test with the OR condition? Dave -- Brevity is the soul of wit. "Richard" wrote: =OR($F$1=5,$O$1=5000)The problem with this formula working is the formula in cell F1 is being read as text (I think) and I need it to read as numerac. Example: The cells that I need are selected and conditional formatted to change to red if these criteria are met. If a 5 is in cell F1 or 5000 in cell O1, The O1 cell works fine because it is a mumeric value but cell F1 has =DATEDIF(A40,TODAY(),"M")&" months " which renders it not working. Any suggestion as to reading F1 as a numeric value without changing this formula in cell F1. Thanks in Advance |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with formula
Thanks for your help!!!
"Kevin B" wrote: Look up IS functions in Excel Help, there's an ISNUMBER or an ISTEXT, as well as other "IS" functions that you can use to evaluate the return value of the formula in cell F1 -- Kevin Backmann "Richard" wrote: =OR($F$1=5,$O$1=5000)The problem with this formula working is the formula in cell F1 is being read as text (I think) and I need it to read as numerac. Example: The cells that I need are selected and conditional formatted to change to red if these criteria are met. If a 5 is in cell F1 or 5000 in cell O1, The O1 cell works fine because it is a mumeric value but cell F1 has =DATEDIF(A40,TODAY(),"M")&" months " which renders it not working. Any suggestion as to reading F1 as a numeric value without changing this formula in cell F1. Thanks in Advance |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with formula
That hit the nail on the head! Thanks! Works great!!!!
"Pete_UK" wrote: Richard, you could try this variation in your CF formula: =OR(LEFT($F$1,1)="5",$O$1=5000) Hope this helps. Pete Richard wrote: =OR($F$1=5,$O$1=5000)The problem with this formula working is the formula in cell F1 is being read as text (I think) and I need it to read as numerac. Example: The cells that I need are selected and conditional formatted to change to red if these criteria are met. If a 5 is in cell F1 or 5000 in cell O1, The O1 cell works fine because it is a mumeric value but cell F1 has =DATEDIF(A40,TODAY(),"M")&" months " which renders it not working. Any suggestion as to reading F1 as a numeric value without changing this formula in cell F1. Thanks in Advance |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with formula
Thanks for feeding back, Richard - glad to be of help.
Pete Richard wrote: That hit the nail on the head! Thanks! Works great!!!! "Pete_UK" wrote: Richard, you could try this variation in your CF formula: =OR(LEFT($F$1,1)="5",$O$1=5000) Hope this helps. Pete Richard wrote: =OR($F$1=5,$O$1=5000)The problem with this formula working is the formula in cell F1 is being read as text (I think) and I need it to read as numerac. Example: The cells that I need are selected and conditional formatted to change to red if these criteria are met. If a 5 is in cell F1 or 5000 in cell O1, The O1 cell works fine because it is a mumeric value but cell F1 has =DATEDIF(A40,TODAY(),"M")&" months " which renders it not working. Any suggestion as to reading F1 as a numeric value without changing this formula in cell F1. Thanks in Advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reusing formula | Excel Discussion (Misc queries) | |||
2 Nesting questions | Excel Worksheet Functions | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |