Multiple functions in single cell

Closed
sudarshandalvi Posts 1 Registration date Thursday May 23, 2013 Status Member Last seen May 23, 2013 - May 23, 2013 at 02:36 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - May 27, 2013 at 11:07 AM
Hello,

I want to put following 2 functions in single cell

ROUND((C365*0.9144),2)
CEILING((D365),0.05)

Pls advise

1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
May 27, 2013 at 11:07 AM
Hi Sudarshandalvi,

Well both formula's give numbers as result.
What do you want to do with those two numbers?

If you want to add them then use the + between the formula's.

Not sure what the problem could be?

Best regards,
Trowa
0