Thread: I need help with a formula values
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bearacade Bearacade is offline
external usenet poster
  
Posts: 1
Default I need help with a formula values

Ok.. Let me see if I understand you correctly...

N2 & I2 = IF(L2="yes", 2, IF(L2="no", 0, False))

P2 & R2 = IF(L2="yes", 1, IF(L2="no", 0, False))

Your cell that combine all the values can be..

IF(L2="yes", 6, IF(L2="no", 0, False))


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=561573

Reply With QuoteReply With Quote