Forum Discussion
Ng yi ling
Jan 30, 2018Copper Contributor
In need of excel formula
I need a formula which is able to fetch me the cell value when w8>x8 to give w8 and when x8> w8 to fetch the value x8 and at the same time give a 15 mins rounding up to the final answer. Anyone can he...
SergeiBaklan
Jan 30, 2018Diamond Contributor
Hi,
That could be like
=IF(W8>X8,W8,CEILING(X8,"00:15"))