| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
function
Can anybody tell me what's wrong with this
=IF(VALUE(O5)=0,"Pull",IF(VALUE(O5)0,"Keep"))=IF( G5="will upd","to be set",""). Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
function
So far, this what I see
If O5=0 then return: "Pull" Otherwise, If 050 then return:"Keep" You also have.... If G5="will upd" then return: "to be set" Otherwise, return an empty string:"" Is there supposed to be a relationship between those 2 phrases? *********** Regards, Ron XL2002, WinXP "algebroni" wrote: Can anybody tell me what's wrong with this =IF(VALUE(O5)=0,"Pull",IF(VALUE(O5)0,"Keep"))=IF( G5="will upd","to be set",""). Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
function
hey Ron what i am trying to do is cell p5 contain either keep pull or to be
set in other words keep and pull depends on O5 And to be set depends on G5. is there anyway to do it or some sort of function. thanks "Ron Coderre" wrote: So far, this what I see If O5=0 then return: "Pull" Otherwise, If 050 then return:"Keep" You also have.... If G5="will upd" then return: "to be set" Otherwise, return an empty string:"" Is there supposed to be a relationship between those 2 phrases? *********** Regards, Ron XL2002, WinXP "algebroni" wrote: Can anybody tell me what's wrong with this =IF(VALUE(O5)=0,"Pull",IF(VALUE(O5)0,"Keep"))=IF( G5="will upd","to be set",""). Thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
function
Well, near as I can guess....
maybe this? P5: =IF(VALUE(O5)=0,"Pull",IF(VALUE(O5)0,"Keep",IF(G5 ="will upd","to be set",""))) Is that something you can work with? *********** Regards, Ron XL2002, WinXP "algebroni" wrote: hey Ron what i am trying to do is cell p5 contain either keep pull or to be set in other words keep and pull depends on O5 And to be set depends on G5. is there anyway to do it or some sort of function. thanks "Ron Coderre" wrote: So far, this what I see If O5=0 then return: "Pull" Otherwise, If 050 then return:"Keep" You also have.... If G5="will upd" then return: "to be set" Otherwise, return an empty string:"" Is there supposed to be a relationship between those 2 phrases? *********** Regards, Ron XL2002, WinXP "algebroni" wrote: Can anybody tell me what's wrong with this =IF(VALUE(O5)=0,"Pull",IF(VALUE(O5)0,"Keep"))=IF( G5="will upd","to be set",""). Thanks |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
function
No it comes up as pull. I guess there is no way to do it. Thanks guys
"Ron Coderre" wrote: Well, near as I can guess.... maybe this? P5: =IF(VALUE(O5)=0,"Pull",IF(VALUE(O5)0,"Keep",IF(G5 ="will upd","to be set",""))) Is that something you can work with? *********** Regards, Ron XL2002, WinXP "algebroni" wrote: hey Ron what i am trying to do is cell p5 contain either keep pull or to be set in other words keep and pull depends on O5 And to be set depends on G5. is there anyway to do it or some sort of function. thanks "Ron Coderre" wrote: So far, this what I see If O5=0 then return: "Pull" Otherwise, If 050 then return:"Keep" You also have.... If G5="will upd" then return: "to be set" Otherwise, return an empty string:"" Is there supposed to be a relationship between those 2 phrases? *********** Regards, Ron XL2002, WinXP "algebroni" wrote: Can anybody tell me what's wrong with this =IF(VALUE(O5)=0,"Pull",IF(VALUE(O5)0,"Keep"))=IF( G5="will upd","to be set",""). Thanks |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
function
"algebroni" wrote:
No it comes up as pull. I guess there is no way to do it ... Another guess ... how about this: =IF(AND(O5="",G5="will upd"),"to be set",IF(AND(O5<"",--O5=0),"Pull",IF(--O50,"Keep",""))) Test it out. See whether it gives you the correct indications under all possible circumstances. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
function
You still haven't specified what you want. Look at it as a truth table.
There are 3 options for VALUE(O5): either 0, 0, or <0. There are 2 options for G5: ="willupd" or <"will upd". That gives you 6 combinations of inputs. What do you want your formula to return for each of those? O5=0 G5="willupd" returns ? O5=0 G5<"willupd" returns ? O50 G5="willupd" returns ? O50 G5<"willupd" returns ? O5<0 G5="willupd" returns ? O5<0 G5<"willupd" returns ? Tell us the 6 answers and we can tell you the formula. -- David Biddulph "algebroni" wrote in message ... No it comes up as pull. I guess there is no way to do it. Thanks guys "Ron Coderre" wrote: Well, near as I can guess.... maybe this? P5: =IF(VALUE(O5)=0,"Pull",IF(VALUE(O5)0,"Keep",IF(G5 ="will upd","to be set",""))) Is that something you can work with? *********** Regards, Ron XL2002, WinXP "algebroni" wrote: hey Ron what i am trying to do is cell p5 contain either keep pull or to be set in other words keep and pull depends on O5 And to be set depends on G5. is there anyway to do it or some sort of function. thanks "Ron Coderre" wrote: So far, this what I see If O5=0 then return: "Pull" Otherwise, If 050 then return:"Keep" You also have.... If G5="will upd" then return: "to be set" Otherwise, return an empty string:"" Is there supposed to be a relationship between those 2 phrases? *********** Regards, Ron XL2002, WinXP "algebroni" wrote: Can anybody tell me what's wrong with this =IF(VALUE(O5)=0,"Pull",IF(VALUE(O5)0,"Keep"))=IF( G5="will upd","to be set",""). Thanks |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
function
If it always comes up as "pull", that indicates It always see value(O5) as 0
What does a cell with =Value(O5) show if O5 will Not be negative I think the equation should be =IF(VALUE(O5)=0,"Pull",P5: =IF(VALUE(G5)="will upd","to be set","Keep") If Value "algebroni" wrote: No it comes up as pull. I guess there is no way to do it. Thanks guys "Ron Coderre" wrote: Well, near as I can guess.... maybe this? P5: =IF(VALUE(O5)=0,"Pull",IF(VALUE(O5)0,"Keep",IF(G5 ="will upd","to be set",""))) Is that something you can work with? *********** Regards, Ron XL2002, WinXP "algebroni" wrote: hey Ron what i am trying to do is cell p5 contain either keep pull or to be set in other words keep and pull depends on O5 And to be set depends on G5. is there anyway to do it or some sort of function. thanks "Ron Coderre" wrote: So far, this what I see If O5=0 then return: "Pull" Otherwise, If 050 then return:"Keep" You also have.... If G5="will upd" then return: "to be set" Otherwise, return an empty string:"" Is there supposed to be a relationship between those 2 phrases? *********** Regards, Ron XL2002, WinXP "algebroni" wrote: Can anybody tell me what's wrong with this =IF(VALUE(O5)=0,"Pull",IF(VALUE(O5)0,"Keep"))=IF( G5="will upd","to be set",""). Thanks |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
function
There are 3 possible results for the first IF statement (excluding any
errors that might be in any of the referenced cells): Pull, Keep, FALSE There are 2 possible results for the second IF statement (excluding any errors that might be in any of the referenced cells): to be set, "" You're comparing equality of the first 3 possibilities to the second 2 possibilitites. Since there is no equality the result will always be FALSE. Biff "algebroni" wrote in message ... Can anybody tell me what's wrong with this =IF(VALUE(O5)=0,"Pull",IF(VALUE(O5)0,"Keep"))=IF( G5="will upd","to be set",""). Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
| Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
| how do I write a vlookup function within an iserror function so t. | Excel Worksheet Functions | |||
| Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions | |||
Hybrid Mode
