Subtract Number With Absolute Number (positive or negative)

[muhammad susanto]

hi all...

how to subtract number with absolute number combination
like this table:

rumus hitung npv 2020 working.xlsx
	G	H	I	J
14	data1	data2
15	35	-28
16	65	128	72	should be
Sheet1

Cell Formulas
Range	Formula
G16:H16	G16	=100-G15

my target in cell G16 & H16
note : i want use single formula, no use Ctrl+Shift+Enter
any help, thank in advance..

.sst

 

[Norie]

Try =100-ABS(G15)

 

[muhammad susanto]

hi Norie, thank you...