How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask Val B Your Own Question
Val B
Val B, Analyst / Trainer
Category: Microsoft Office
Satisfied Customers: 54
Experience:  Expert in solving Microsoft Office problems.
36150026
Type Your Microsoft Office Question Here...
Val B is online now
A new question is answered every 9 seconds

i need to create an if then formula for my spreadsheet, if

This answer was rated:

i need to create an if then formula for my spreadsheet, if cell C30 = 1 then I want cell D30 to be (Cell L7/12); if cell C30 = 2 then I want cell D30 to be (Cell K7/12)

Hello,

You can accomplish this by putting the following nested IF formula into field D30:

=IF(C30=1,(L7/12),IF(C30=2,(K7/12)))

Val

Val B and other Microsoft Office Specialists are ready to help you
Customer: replied 4 years ago.


Hi, I was just able to confirm your formula for my spreadsheet, it works like a charm!!


 


THanks,



Scott

Customer: replied 4 years ago.


Can you put MS Outlook upload to skydrive?