Combined Excel Formula

[Sujit Naha]

example:
%
1) Result ---------- 100 - 1.5 = 1.5 ( percentage formula)

2) Result ---------- 100 - 1.5 = 1.0 ( If (MOD)) formula

Question: Please Let Me the Combined Formula for above i.e. Percentage + If Mod formula in One Cell

Please reply and do needful

 

[RAJESH NATH]

I think you required this...

practice.xlsx
	B	C	D
10	100	1.5	1.5
11	100	1.5	1
12	100	1.5	2.5
Sheet7

Cell Formulas
Range	Formula
D10	D10	=B10*C10%
D11	D11	=MOD(B11,C11)
D12	D12	=(B12*C12%)+(MOD(B12,C12))