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

Reply With QuoteReply With Quote