View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
spaceage spaceage is offline
external usenet poster
 
Posts: 18
Default Multiple logical formula

i wud like to put this formula in excel,if someone can please guide me,

if c1a1 and if c1b1 then d1=0,
if c1a1 and if c1<b1 then d1=c1-b1
if c1<a1 and if c1<b1 then d1=a1-b1
and
if c1<a1 and c1b1 then d1=a1-c1
--
thanks and
rgds

amit