Need help with formula

Originally Posted by htmldiva

I'm working on a timesheet and need help with an IF statement. How do i write:

1) If cell N8 = "Personal", then cell A1=this formula and Cell A2 =that formula, else keep existing formulas

Thanks!

I think you should have two IF statements for this. The formula


=IF(N8="Personal",use_this_formula,keep_existing_formula)


should be entered in Cell A1, while in Cell A2, the formula is


=IF(N8="Personal",use_that_formula,keep_existing_formula)

Hope this will help you.