IF with multiple condition and ABS

[jani.pk]

dear friend,
please help with this,

a scenario like this;

coloum A coloum B coloum C
DEBIT/CREDIT/REFILL 10000 result(formula)

RESULT IN C
if coloum A contains Debit or Refill then coloum C result would be of coloum B same value 100000 but if coloum A is Credit then coloum C result would be negative -10000

thanks in advance.

[BadlySpelledBuoy]

In C2 (assuming your data starts on row 2) try =IF(A2="","",IF(OR(A2="Debit",A2="Refill"),-B2,B2)) and copy down.

[jani.pk]

i think i am unable to explain it properly i have attach the sheet and i need the coloum in result highlithed in yelllow.

[BadlySpelledBuoy]

=IF(A2="","",IF(OR(A2="Debit",A2="Refill"),B2,-B2))

Enter the above slightly amended formula in C2 and copy down as needed.

[jani.pk]

yes thats great.

thanx brother.

[BadlySpelledBuoy]

No problem.

Apologies, it was my misreading of your original post that lead to the incorrect formula at first.

Thanks for the feedback and please mark the post as "SOLVED" if you're happy you have a working answer.

BSB.