Posted by Joanne Stanley on November 22, 2001 6:26 AM
I need to calculate a formula so that it gives me a total and not #VALUE
It needs to calculate information in three cells
What I need to do is to make it so that if cell1 contains a value of one then the total must be blank (FALSE) but in the same formula i also need it to give me a value if cell2 is more than 1. Cell three is the value and does not need to be calculated just moved to the new cell and only show a value if it covers the criteria of the above.