Can someone guide me in the best formula to use to not do anything if a cell has a zero in it, but if a cell has a number greater than 0 in it, it goes and grabs information from another cell...
i.e..... I want to put a date into cell C20 but not if D20 has a zero in it, as soon as D20 has any number greater than zero, then I want it to go to F20 and put the date from that cell into C20.
Thank you so much in advance.
Cheers
Liam
Bookmarks