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.

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(A20,B20),"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.

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

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

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