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.
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.
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
what is >?
"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
>
and what is "?
"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
>
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
>
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
>
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks