Thread: IF statement that yields a value based on a formula
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default IF statement that yields a value based on a formula
Hi,

Try this

=MAX(0,B12*0.4)
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"barbara h" wrote:

Help! If cell B12 = 0, then I need the answer to be calculated based on the
formual "B12 * .40". If cell B12 < 0, then the answer is zero.

How do I do this?
--
barbara h
Reply With QuoteReply With Quote