hi, can you please help me, I need an "if" formula, but can't seem to understand the info given in most books.
I have 5 cells A-E named Distance, Time, Race time, Diff, Going
my normal calc is (D/A)*3 which gives me E
I need a formula that shows 0 in E if 0 is entered in C or else shows my original calc.
Hope you can understand my query.
regards
David B
I have 5 cells A-E named Distance, Time, Race time, Diff, Going
my normal calc is (D/A)*3 which gives me E
I need a formula that shows 0 in E if 0 is entered in C or else shows my original calc.
Hope you can understand my query.
regards
David B