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 help me? :(

Would appreciate if any kind soul could help me with it :( because I think abt it for 2 days also cannot get the answer

Hi, That could be like =IF(W8>X8,W8,CEILING(X8,"00:15"))

Forum Discussion

Copper Contributor

Jan 30, 2018

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 help me? :(

Formulas & Functions

training

2 Replies

SergeiBaklan
Diamond Contributor
Jan 30, 2018
Hi,

That could be like

=IF(W8>X8,W8,CEILING(X8,"00:15"))
Ng yi ling
Copper Contributor
Jan 30, 2018
Would appreciate if any kind soul could help me with it :( because I think abt it for 2 days also cannot get the answer