Excel formula assistance

[Bmahat]

Dear Team,

Please help me to get below solved. Thank you.

Required formula	Cell "F"	Cell "G"
	Amount	Debit/Credit
if G6 is "C" F6 cell value in -1000	1000	C
if G7 is D"" F7 cell value in 2500	2500	D
if G8 is "C" F8 cell value in -900	900	C
if G9 is "C" F9 cell value in -2000	2000	C
if G10 is "D" F10 cell value in 199	199	D

[#2 · Accepted solution]

You should add an additional column for this with a formula like:
=IF(G6="D",F6,-F6)

[#3]

@Bmahat 

As variant

=F6*(1-2*(G6="C"))