Can't seem to get my head around this one (perhaps it's late).... scenario is like this.... I need to get either a "blank" or "zero" in cell AD8, by way of looking at AD4, if this is blank then blank in AD8, however if AD4 isn't blank BUT AD5 is "0" then I need AD8 to also show "0", BUT if AD4 isnt blank and AD5 isn't zero then I need AD8 to DIVIDE AD7 by AD6
Thanks all for the replies, sorry I didn't reply, but the clue was in my posting (I fell asleep), anyway its now 7.35am and I will put the replies to the test when I get work in the next hour,,, will post the outcome later today. Many Thanks for your replies
This thread is now locked and can not be replied to.