Thread: multiply with - if text
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
potzo
 
Posts: n/a
Default multiply with - if text

it works after i strggled a little bit
=IF(E3="$";F3*J2;IF(E3="?";F3*I2;))


--
potzo
------------------------------------------------------------------------
potzo's Profile: http://www.excelforum.com/member.php...o&userid=33901
View this thread: http://www.excelforum.com/showthread...hreadid=537998

Reply With QuoteReply With Quote