+ Reply to Thread
Results 1 to 7 of 7

how 2 make one cell change title when either of 2 other are > 1

Hybrid View

  1. #1
    confuscious
    Guest

    how 2 make one cell change title when either of 2 other are > 1

    i want to make a cell [heading 1] (that is a list of two headings) change to
    [heading 2] if either one of two other cells are greater than 0 but revert
    back to [heading 1] if not.

  2. #2
    Dave Peterson
    Guest

    Re: how 2 make one cell change title when either of 2 other are > 1

    In the Heading cell:

    =if(max(c9,d37)>0,"Heading2here","heading1here")

    confuscious wrote:
    >
    > i want to make a cell [heading 1] (that is a list of two headings) change to
    > [heading 2] if either one of two other cells are greater than 0 but revert
    > back to [heading 1] if not.


    --

    Dave Peterson

  3. #3
    confuscious
    Guest

    Re: how 2 make one cell change title when either of 2 other are >

    what is &gt?

    "Dave Peterson" wrote:

    > In the Heading cell:
    >
    > =if(max(c9,d37)>0,"Heading2here","heading1here")
    >
    > confuscious wrote:
    > >
    > > i want to make a cell [heading 1] (that is a list of two headings) change to
    > > [heading 2] if either one of two other cells are greater than 0 but revert
    > > back to [heading 1] if not.

    >
    > --
    >
    > Dave Peterson
    >


  4. #4
    confuscious
    Guest

    Re: how 2 make one cell change title when either of 2 other are >

    and what is &quot?

    "Dave Peterson" wrote:

    > In the Heading cell:
    >
    > =if(max(c9,d37)>0,"Heading2here","heading1here")
    >
    > confuscious wrote:
    > >
    > > i want to make a cell [heading 1] (that is a list of two headings) change to
    > > [heading 2] if either one of two other cells are greater than 0 but revert
    > > back to [heading 1] if not.

    >
    > --
    >
    > Dave Peterson
    >


  5. #5
    confuscious
    Guest

    Re: how 2 make one cell change title when either of 2 other are >

    this things weird. the response screen has a whole load of jibberish
    characters on it. it seem to be normal on this reply widow though. ill just
    go try it. cheers. ill let you know if it helps.

    "Dave Peterson" wrote:

    > In the Heading cell:
    >
    > =if(max(c9,d37)>0,"Heading2here","heading1here")
    >
    > confuscious wrote:
    > >
    > > i want to make a cell [heading 1] (that is a list of two headings) change to
    > > [heading 2] if either one of two other cells are greater than 0 but revert
    > > back to [heading 1] if not.

    >
    > --
    >
    > Dave Peterson
    >


  6. #6
    confuscious
    Guest

    Re: how 2 make one cell change title when either of 2 other are >

    thats it. thanks very much.

    "Dave Peterson" wrote:

    > In the Heading cell:
    >
    > =if(max(c9,d37)>0,"Heading2here","heading1here")
    >
    > confuscious wrote:
    > >
    > > i want to make a cell [heading 1] (that is a list of two headings) change to
    > > [heading 2] if either one of two other cells are greater than 0 but revert
    > > back to [heading 1] if not.

    >
    > --
    >
    > Dave Peterson
    >


  7. #7
    StinkeyPete
    Guest

    RE: how 2 make one cell change title when either of 2 other are > 1

    If I understood your question correctly thy this:

    in cell A1 copy and paste this formula
    =IF(OR(A2>0,B2>0),"Heading2","Heading1")

    "confuscious" wrote:

    > i want to make a cell [heading 1] (that is a list of two headings) change to
    > [heading 2] if either one of two other cells are greater than 0 but revert
    > back to [heading 1] if not.


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1