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?
Not entirely sure what you are asking... but see if this helps.
In E32 =IF(D32<0,"Over Budget","")
George Gee
"Vivek" <[email protected]> wrote in message
news:[email protected]...
> If I have one cell - d32, and when the value becomes negative I want cell
> E32
> to say "Over Budget", would this be possible?
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?
"George Gee" wrote:
> Not entirely sure what you are asking... but see if this helps.
> In E32 =IF(D32<0,"Over Budget","")
>
> George Gee
>
> "Vivek" <[email protected]> wrote in message
> news:[email protected]...
> > If I have one cell - d32, and when the value becomes negative I want cell
> > E32
> > to say "Over Budget", would this be possible?
>
>
>
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
"Vivek" <[email protected]> wrote in message
news:[email protected]...
> 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?
>
> "George Gee" wrote:
>
>> Not entirely sure what you are asking... but see if this helps.
>> In E32 =IF(D32<0,"Over Budget","")
>>
>> George Gee
>>
>> "Vivek" <[email protected]> wrote in message
>> news:[email protected]...
>> > If I have one cell - d32, and when the value becomes negative I want
>> > cell
>> > E32
>> > to say "Over Budget", would this be possible?
>>
>>
>>
Thanks so much, it works!!!
"George Gee" wrote:
>
>
> 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
>
>
>
>
>
> "Vivek" <[email protected]> wrote in message
> news:[email protected]...
> > 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?
> >
> > "George Gee" wrote:
> >
> >> Not entirely sure what you are asking... but see if this helps.
> >> In E32 =IF(D32<0,"Over Budget","")
> >>
> >> George Gee
> >>
> >> "Vivek" <[email protected]> wrote in message
> >> news:[email protected]...
> >> > If I have one cell - d32, and when the value becomes negative I want
> >> > cell
> >> > E32
> >> > to say "Over Budget", would this be possible?
> >>
> >>
> >>
>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks