Thread: IF function for multiple variables
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
  
Posts: 5,651
Default IF function for multiple variables
On Fri, 24 Aug 2007 10:52:05 -0700, DaS wrote:

=if(a3="Saturday",420,if(a3="sunday",348,if(a3="f riday",378,172)))

=IF(WEEKDAY(A3)=7,420,IF(WEEKDAY(A3)=1,348,IF(WEEK DAY(A3)=6,378,172)))
--ron
Reply With QuoteReply With Quote