Forum home » Delegate support and help forum » Microsoft Excel Training and help » advanced.excel - IF function
|
|
|
The UK's most regular 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. |
advanced.excel - IF function
Resolved · Low Priority · Version Standard
Reply Thu 6 Sep 2007, 15:48Delegate Tim said...
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)))
For upcoming training course dates see: Pricing & availability
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
|