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)))
Mon 10 Sep 2007, 15:43Trainer Katie said...
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
