Sujit Naha
New Member
- Joined
- Aug 26, 2020
- Messages
- 5
- Office Version
- 2007
- Platform
- Windows
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
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