Thread: testing data in above cell, and choosing column to copy from
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
OTWarrior via OfficeKB.com OTWarrior via OfficeKB.com is offline
external usenet poster
  
Posts: 14
Default testing data in above cell, and choosing column to copy from
i have a cell which wil set a value (5, 10, ETC). and depending on this value,
chnage the boxes below it.
i currenlty have:

=IF(B8=G8,G9,0)

which changes the cell is one criteria is met. however i want

=IF(B8=G8,G9,0) or IF(B8=j8,j9,0) or IF(B8=h8,h9,0)

can this be done in a cell? and if so, what is the syntax for separateing the
exprressions ("IF(B8=j8,j9,0)")?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200705/1

Reply With QuoteReply With Quote