I don't really understand IF functions (or Excel) in any great depth! At the moment I'm trying something that I think is a bit above my head and I'd love it if someone could help me and explain why you do what you do.
I have 3 colums (A,B+C), each with about 1,500 values in ranging from 0 to 11. the 5th colum in the row display a value based on a formula. I'm trying to do a conditional format so if two of the first colums have a 0 in then the answer is a certain colour, if there's only one another, and if there aren't any zero's a final colour.
So i'm trying to put an IF formula into my conditional format box.
The formula for colum number 5 is:
=SUMPRODUCT($A$1:$C$1,A205:C205)
So I think I want to write something along the lines of:
=IF($A=0$B=0, and then have my true value set to the colour, say blue.
But how do I write this properly, I really dont understand!
Also as a side note, if I had an IF function, what would i need to write in the true value space to get the cell just to display the result of a formula?
Thank you very much for your help.
I have 3 colums (A,B+C), each with about 1,500 values in ranging from 0 to 11. the 5th colum in the row display a value based on a formula. I'm trying to do a conditional format so if two of the first colums have a 0 in then the answer is a certain colour, if there's only one another, and if there aren't any zero's a final colour.
So i'm trying to put an IF formula into my conditional format box.
The formula for colum number 5 is:
=SUMPRODUCT($A$1:$C$1,A205:C205)
So I think I want to write something along the lines of:
=IF($A=0$B=0, and then have my true value set to the colour, say blue.
But how do I write this properly, I really dont understand!
Also as a side note, if I had an IF function, what would i need to write in the true value space to get the cell just to display the result of a formula?
Thank you very much for your help.