Need Help with Formula

[bamaisgreat]

I need help with the formula below.
I need it to NOT do the 0.09*C4 when CASH WPT is in c4

=IF(F4<>"CASH WPT",0,0.09*C4)

 

[Michael M]

Do you mean like this...

=IF(AND(F4<>"CASH WPT",C4="CASH WPT"),0,0.09*C4)

 

[bamaisgreat]

I need TAX 9% which is D4 to be 0 if F4 says Cash WPT

=IF(F4<>"CASH WPT",0,0.09*C4)​

<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>

<colgroup><col style="width: 60px"><col width="62"><col width="55"><col width="100"><col width="100"><col width="100"><col width="100"></colgroup><tbody>
[TD="align: center"]Pallet Number[/TD]
[TD="align: center"]Price Marked[/TD]
[TD="align: center"]Sold For[/TD]
[TD="align: center"]Tax 9%[/TD]
[TD="align: center"]CC 3%[/TD]
[TD="align: center"]Payment Method[/TD]
[TD="align: center"]Total[/TD]

[TD="align: center"]A1[/TD]
[TD="align: center"]350.00[/TD]
[TD="align: center"]325.00[/TD]
[TD="align: center"]29.25[/TD]
[TD="bgcolor: #fafafa, align: center"]0.00[/TD]
[TD="align: center"]Cash WPT



[/TD]
[TD="bgcolor: #ff9900, align: center"]354.25[/TD]

</tbody>

<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>

 

[Michael M]

Just change the "<>" to an = sign...

=IF(F4="CASH WPT",0,0.09*C4)

 

[Michael M]

Try staying with 1 thread ...

Duplicate thread

https://www.mrexcel.com/forum/excel-questions/985544-need-help-simple-formula.html