Thread: How do I calculate in an IF
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PCLIVE PCLIVE is offline
external usenet poster
  
Posts: 168
Default 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?


Reply With QuoteReply With Quote