Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

advanced.excel - if function

Forum home » Delegate support and help forum » Microsoft Excel Training and help » advanced.excel - IF function

advanced.excel - IF function

ResolvedVersion 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

Excel tip:

Highlighting only Text cells

To select onlt text value cells in a spreadsheet, click on Edit-Go to(F5)


In the Go To dialog box, click Special.
In the Go To Special dialog box, select Constants.
Click OK.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.