If column 3 is greater than 10, then i need the formula in column 1 be use and if column 3 is lesser than 10 formula in column 2 should be use. I am putting this formula in column 4. Please i just badly needed it! Thanks...
In column4 write:
=IF(column3 >=10, column1, column2)
this should do it...
:-)
It works! thank you...
