View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Patrick Patrick is offline
external usenet poster
 
Posts: 160
Default Nesting with "IF"

I thought this would be easy but I am drawing a blank. I just need a formula
in a cell that does the following: Assuming I want the value to come up in
cell I need to tell that cell

IF A1=2, value if true 100-25, value if false 100; IF A1=3, VIT 100-50, VIF
100; IF A1=4, VIT 0, VIF 100.

I can do one IF analysis but can't seem to get all three in one formula.
Thank you!