Hi there, my spreadsheet has 5 columns, with headings.. A-date, B-enter long, C-enter short, D-exit, e-%. I would like to create a formula to calculate % in column e. If column a-date is blank, e remains blank. If a date is listed in column a, and a number is listed in b&D, e = ((d-b)/d), if B is blank and a number is listed in C&D, e=((d-c/d). I would like to create a formula that will combine these if/and scenarios and give me one result in column e. There will always be only one number in B or C. Thanks.