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

[confuscious]

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]

In the Heading cell:

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

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.

 

[StinkeyPete]

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]

what is &gt?

In the Heading cell:

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

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.

 

[confuscious]

and what is &quot?

In the Heading cell:

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

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.

 

[confuscious]

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.

In the Heading cell:

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

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.

 

[confuscious]

thats it. thanks very much.

In the Heading cell:

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

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.