Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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. |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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 |
#7
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Possible Lookup Table | Excel Worksheet Functions | |||
How do I make it change colour | Excel Worksheet Functions | |||
make a cell empty based on condition | Charts and Charting in Excel | |||
make cell contents equal to null value - not blank, but empty | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |