can someone help!
Posted by David on December 14, 2001 8:01 AM
I was wondering if someone coule tell me if it is possible to have a number in a cell & an if statement(or anything else), which will alter the value in the cell, if another variable is true, but otherwise leave it?! erm i dont know if that made any sense, but im only 16 and im having soem trouble with this! Please email me if you can help or reply to this thanks!
Posted by Brian on December 14, 2001 8:19 AM
I think I follow you. If Cell x equals y then you want it to return that value. Otherwise, make it equal to 1. Is that kinda what you're after? If so, try this.
=if(a1=b2,a1,1)
where you want the cell to equal a1 ONLY if a1 equals b1, otherwise make it equal 1. Hint: you can also make it return text by replacing the number 1 in the formula above to "ERROR" for instance. Just make sure you put the text in quotation marks. Hope this helped.
