Thread: IF maximums
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
B G B G is offline
external usenet poster
 
Posts: 11
Default IF maximums

Awesome - thank you so much.
--
Barb


"Excelenator" wrote:


The problem is the ")" after C9 in your formula. It should be removed
and an additional ")" should be placed at the end of the formula.

=IF(OR(C11="BR",C11="FW",C11="HI",C11="NE"),34*C13 *C9*)*,IF(C11="BL",B3*C13*C9,IF(C11="EP",B5*C13*C9 ))


--
Excelenator


------------------------------------------------------------------------
Excelenator's Profile: http://www.excelforum.com/member.php...o&userid=36768
View this thread: http://www.excelforum.com/showthread...hreadid=565270