View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Vito
 
Posts: n/a
Default If Statement and two metrics


You were on the right track :)

=if(and(a6<2.5,c674),(c10+(c10*.10),0))


if the 74 is a result of a sum of numbers, use the sum function,
=Sum(value1,value2,etc) or =Sum(cell_ref1:cell_ref2)


--
Vito
------------------------------------------------------------------------
Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182
View this thread: http://www.excelforum.com/showthread...hreadid=492882