if cell contain a specific text then add specific number if not add another number

[Fielt21]

Hello, just some simple question about excel formula.
For example if between cell B2 until H2 contain "Paid" then add 5000 to I2 if contain "Unpaid" then minus 5000.

http://postimg.org/image/pr1ieq1ld/

Thanks.

[weresmytriple]

hi its not the cleanest way to do what your asking but its the simplest

you can then hide I:P (once you have the formula copied for all rows)

[Beamernsw]

Try this:-

=IF(COUNTIF($B1:$H1,"Paid")>0,[existing formula]+5000,IF(COUNTIF($B1:$H1,"Unpaid")>0,[existing formula]-5000,[existing formula]))

[Tony Valko]

Try this...

Data Range

	B	C	D	E	F	G	H	I
1
2	Paid	Paid	Unpaid	Paid	Paid	Unpaid	Paid	15000
3

This formula entered in I2:

=SUM(COUNTIF(B2:H2,{"Paid","Unpaid"})*{5000,-5000})

[Fielt21]

Thank you for the reply guys.
Worked perfectly fine :D

[Tony Valko]

You're welcome. We appreciate the feedback!