Combined Formula in One Cell

[Sujit Naha]

For Example :- ( Total Cell No. A , B, C, D )

1) Result : -- A -100 B - 1.5 = C- 1.5 ( Percentage formula : = A * B %

Continuation of 1st Result :

2) C-1.5 = D-1.0 ( Formula : = IF ( MOD ( C , 1 ) > 0.5 , INT ( C ) + 1 , INT ( C ) )

Question: How to Combine above Two Formulas in Cell - C

 

[Fluff]

How about
=IF(MOD(A2*B2%,1)>0.5,INT(A2*B2%)+1,INT(A2*B2%))

 

[Sujit Naha]

How about
=IF(MOD(A2*B2%,1)>0.5,INT(A2*B2%)+1,INT(A2*B2%))

--------------- Many Many Thanks Sir .......... Great Knowledge given to Me ... its works fine .... thanks a lot

 

[Fluff]

You're welcome & thanks for the feedback.