Thread: =IF(D43=45*D43<=87,"5.00","0.00")
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary Gary is offline
external usenet poster
  
Posts: 143
Default =IF(D43=45*D43<=87,"5.00","0.00")
Mike" wrote in message
...

I'm trying to get a formula to be between two numbers. Is my * my problem


Try

=if(and(D43=45,D43<=87),"5.00","0.00")

is this what u need?


Reply With QuoteReply With Quote