Formula require

[Ketan_ashiyani]

Dear Team

We need to solution as per attached sheet and screen shot.

Note Type

Result Require :

1. State cell is Blank Result require is 0,
2. Type cell is C and State Cell is not blank. The result required is (-) negative value
3. Type cell is Blank and state cell is not blank result required is positive value

Type	State	Amount in INR	Result Require
	08-Rajasthan	100
	23-Madhya Pradesh	200
C	24-Gujarat	300
		600
	27-Maharashtra	1,000
	08-Rajasthan	2,000
		3,000
C	27-Maharashtra	5,000

 

[hagia_sofia]

Hello, like this?

=IFS(ISBLANK(B2),0,AND(A2="C",ISTEXT(B2)),-C2,AND(ISBLANK(A2),ISTEXT(B2)),C2)

 

[Kaper]

in D2 (adjust if your screenshot does not start from A1) formula:

=IF(B2<>"",IF(A2="C",-C2,C2),0)

and copy down

 

[kvsrinivasamurthy]

Try in C2

=IF(B2="",0,IF(B2<>"",-1*ABS(C2),IF(AND(A2="",B2<>""),ABS(C2),"")))

 

[KOKOSEK]

We do not need nesting IFs:

=IFS($B3="",0,AND($A3="C",$B3<>""),-$C3,AND($A3="",$B3<>""),C3)