Thread: =IF(D43=45*D43<=87,"5.00","0.00")
View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.worksheet.functions
edwardpestian edwardpestian is offline
external usenet poster
  
Posts: 1
Default =IF(D43=45*D43<=87,"5.00","0.00")

Try this. Enter as an array formula


Code:
--------------------


=IF((B4414)*(B44<24)*(D4444)*(D44<88)*(F44999)* (F44<1276)," $75.00",IF((B4414)*(B44<24)*(D4444)*(D44<88),"$3 7.50","$0.00"))


--------------------


--
edwardpestian
------------------------------------------------------------------------
edwardpestian's Profile: http://www.excelforum.com/member.php...o&userid=33809
View this thread: http://www.excelforum.com/showthread...hreadid=562311

Reply With QuoteReply With Quote