G Guest Mar 5, 2006 #1 If I have one cell - d32, and when the value becomes negative I want cell E32 to say "Over Budget", would this be possible?
If I have one cell - d32, and when the value becomes negative I want cell E32 to say "Over Budget", would this be possible?
G George Gee Mar 5, 2006 #2 Not entirely sure what you are asking... but see if this helps. In E32 =IF(D32<0,"Over Budget","") George Gee
Not entirely sure what you are asking... but see if this helps. In E32 =IF(D32<0,"Over Budget","") George Gee
G Guest Mar 5, 2006 #3 It works, thanks a lot! I also want to do the same thing when D32 is positive with the same cell. How do you do this?
It works, thanks a lot! I also want to do the same thing when D32 is positive with the same cell. How do you do this?
G George Gee Mar 5, 2006 #4 In E32 =IF(D32<0,"Over budget","On Target") Change the text *On Target* to whatever you wish to appear. Is this what you want, if not, post back with more details. George Gee
In E32 =IF(D32<0,"Over budget","On Target") Change the text *On Target* to whatever you wish to appear. Is this what you want, if not, post back with more details. George Gee
G Guest Mar 5, 2006 #5 Thanks so much, it works!!! George Gee said: In E32 =IF(D32<0,"Over budget","On Target") Change the text *On Target* to whatever you wish to appear. Is this what you want, if not, post back with more details. George Gee Click to expand...
Thanks so much, it works!!! George Gee said: In E32 =IF(D32<0,"Over budget","On Target") Change the text *On Target* to whatever you wish to appear. Is this what you want, if not, post back with more details. George Gee Click to expand...
