Nesting IF Statements
Posted by Jan on January 10, 2002 11:52 AM
i have pasted this formula into a cell
it's supposed to check each box above it for a value.
if d3 is 0 insert the value for d4
if d4 is 0 insert the value for d5
if d5 is 0 insert the value for d6
what is wrong with my code? is there an easier way to do this?