Thread: conditional formulas
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Danno[_2_] Danno[_2_] is offline
external usenet poster
  
Posts: 5
Default conditional formulas
Anyone know how to write a formula for this?

IF(I12N12) then J12=(N12-D12) but if(I12<N12) then J12=(I12-D12)

where I12 is derived from another formula (=SUMC12+M12) and C12, M12 and N12
are simply input numbers.
Reply With QuoteReply With Quote