Thread: need help on a formula
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
daddylonglegs daddylonglegs is offline
external usenet poster
  
Posts: 1
Default need help on a formula

Try amending Dav's formula as follows:

=IF(B1="","",IF(OR(A1="company1",A1="company2"),B1 +3,IF(OR(A1=
"company3",A1="company4"),B1+5,B1+30)))


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=574130

Reply With QuoteReply With Quote