Thread: IF THEN Statement
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eduardo Eduardo is offline
external usenet poster
  
Posts: 2,276
Default IF THEN Statement
Hi,

=if(B120,(B13*0.40),0)

"barbara h" wrote:

I need to do a calculation based on a cell. If cell B12 = 0, then I need
to calculate a formula (B13*.40). If cell B12 < 0, then value = 0.

Can anybody help?

--
barbara h
Reply With QuoteReply With Quote