How do I calculate in an IF

T

Takia

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?
 
L

luiz

"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?
Click to expand...
You have to do the following:=IF(B8>5000;B8*2%;0)
 
Top