Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I am trying to use the IF formula in excel but am getting errors.

In Column E i have the business type which consists of New Business, Renewals, Upsells.

If the value is New Business or Upsell I need to have the value of 4500 entered, if it equals Renewal i need to have the value 300 entered

share|improve this question

3 Answers 3

up vote 0 down vote accepted

Use

=IF(OR(E2="New Business",E2="Upsell"),4500,IF(E2="Renewal",300,""))

or

=IF(OR(E2="New Business",E2="Upsell"),4500,300)
share|improve this answer
1  
=IF(E2="Renewal",300,4500) is slightly more compact. (Thank you for all your other contributions too!) –  pnuts Mar 13 '13 at 8:41

This should work. Assuming your header information is in row 1 and data starts in row 2, if you place this formula in F2 (or whichever column you want your data to appear) and copy-down to the last row in your sheet, you should get the right answer for each value.

=if(or(E2="New Business", E2="Upsell"), 4500, 300)
share|improve this answer
1  
i'm a pedant meself. it was no trouble. re: OR, I lean the other way. It's more cumbersome, but future maintainers of the spreadsheet will have more idea of what's going on if everything's identified. Worse (perhaps), i also want to change the last ,"" to catch everything else and return "Invalid Type" –  mcalex Mar 14 '13 at 11:57

Based on Microsoft , here is a useful link: How to use IF function in Excel

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.