98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » advanced.excel - IF function
advanced.excel - IF function
Resolved · Low Priority · Version Standard
Tim has attended:
Excel Intermediate course
Excel Advanced course
Excel Advanced course
IF function
I am trying to use the IF function but it keeps saying my logical test is invalid. What I am trying to do is to say if a letter is in one cell then this cell should show a particular number, if the other cell shows another letter, it should show a different number etc.
What is wrong with the following...
=IF(G7='GE', 1500,IF(G7='Enercon',800, IF(G7='Gamesa',850)))
RE: IF function
Hi Tim,
All text should be double quote not single quote
=IF(G7="GE", 1500,IF(G7="Enercon",800, IF(G7="Gamesa",850)))
Hope this helps.
Katie
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Keyboard Shortcuts to Add Rows or ColumnsCouple of other keyboard shortcuts. Shift+spacebar selects a row, Ctrl+spacebar selects a column. Select either row or column (or several) and use Ctrl and + to insert or Ctrl and - to delete rows or columns. |