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