if statement please

[search4f]

i appreciate your help
i need something to add .04 percent tax if the figure is $45000 or greater
lets sale b2 is my selling price then b7 would be 0 unless b2 is $5k or more thanks

 

[RCBricker]

=if(b2>=5000,b2*.04,0)

or since the first part of your question mentioned $45000

=if(b2>=45000,b2*.04,0)

 

[search4f]

=if(b2>=5000,b2*.04,0)

or since the first part of your question mentioned $45000

=if(b2>=45000,b2*.04,0)

Thank you so very much for the quick reply another question please
If I wanted this only to apply to a new car and not a used one could have a dropdown or check box to pick new or used in a cell and then make this formula work if new only. Thanks again

 

[RCBricker]

Assume cell C2 says new or used

=if(C2="Used","",if(b2>=5000,b2*.04,0))

 

[search4f]

Assume cell C2 says new or used

=if(C2="Used","",if(b2>=5000,b2*.04,0))

Thanks

 

[arthurbr]

Cross post if statment