ExcelBanter - How do I calculate in an IF

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I calculate in an IF (https://www.excelbanter.com/excel-worksheet-functions/106757-how-do-i-calculate-if.html)

Takia

How do I calculate in an IF

I need to do a formula that if B8 is greater then $5000 then I need B8*2%, if
it is less I need zero. Does anyone have any suggestions?

PCLIVE

How do I calculate in an IF

=IF(B85000,B8*.02,0)

"Takia" wrote in message
...
I need to do a formula that if B8 is greater then $5000 then I need B8*2%,
if
it is less I need zero. Does anyone have any suggestions?

tim m

How do I calculate in an IF

=IF(B85000,B8*0.02,0)

"Takia" wrote:

I need to do a formula that if B8 is greater then $5000 then I need B8*2%, if
it is less I need zero. Does anyone have any suggestions?

luiz

How do I calculate in an IF

"Takia" escreveu:

I need to do a formula that if B8 is greater then $5000 then I need B8*2%, if
it is less I need zero. Does anyone have any suggestions?
You have to do the following:=IF(B85000;B8*2%;0)

All times are GMT +1. The time now is 01:21 PM.