Thread: If then formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Libby Libby is offline
external usenet poster
 
Posts: 151
Default If then formula

I want to write a formula to do the following:

If column w= 1 and column t-u <0 and column t-u <= 50 and column t-u +
-100 then return the word "immaterial" in column v else if column w=1 and
column t-u = 0 then return "pb" in column v else leave column v blank
--
Libby