Thread: IF Formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JW[_2_] JW[_2_] is offline
external usenet poster
  
Posts: 638
Default IF Formula
=IF(B2=2006,15,IF(B2=2007,30,IF(B2=2008,45,"no match")))

bmo wrote:
I have an if formula "=IF(B2=2006,15)" which works fine, but I would like to
expand it to also include "=IF(B2=2007,30)", but I can't figure out how to
write it. I would even like "=IF(B2=2008,45)" if its possible.

Thanks,

Reply With QuoteReply With Quote