why If, THEN does not work

[childothe1980s]

Hello:

I'm trying to get a very simple nested IF, THEN statement to work. But,
instead of returning a value, it returns "FALSE". I really don't get it.
Below is my formula. Please help!!!

=IF($K2="HW","70", IF($K2="SW","75", IF($K2="A","01", IF($K2="LI", "20",
IF($K2="F", "60")))))

childofthe1980s

[davesexcel]

works for me, what are you finding it does for you??

[davesexcel]

=IF($K2="HW","70", IF($K2="SW","75", IF($K2="A","01", IF($K2="LI", "20",IF($K2="F", "60","")))))
you were missing the last 2 quotes at the end of the formula, if L2 does not meet any of the criteria, then it will show blank you can enter other values if you wish, for text just insert in the quotes, numbers don't use quotes

[Niek Otten]

<IF($K2="F", "60")))))>

And what if $K2 not equals "F"?

Your formula is not complete

--
Kind regards,

Niek Otten


"childothe1980s" <[email protected]> wrote in message
news:[email protected]...
> Hello:
>
> I'm trying to get a very simple nested IF, THEN statement to work. But,
> instead of returning a value, it returns "FALSE". I really don't get it.
> Below is my formula. Please help!!!
>
> =IF($K2="HW","70", IF($K2="SW","75", IF($K2="A","01", IF($K2="LI", "20",
> IF($K2="F", "60")))))
>
> childofthe1980s

[childothe1980s]

I really don't know what you mean. Could you please explain?

childofthe1980s

"Niek Otten" wrote:

> <IF($K2="F", "60")))))>
>
> And what if $K2 not equals "F"?
>
> Your formula is not complete
>
> --
> Kind regards,
>
> Niek Otten
>
>
> "childothe1980s" <[email protected]> wrote in message
> news:[email protected]...
> > Hello:
> >
> > I'm trying to get a very simple nested IF, THEN statement to work. But,
> > instead of returning a value, it returns "FALSE". I really don't get it.
> > Below is my formula. Please help!!!
> >
> > =IF($K2="HW","70", IF($K2="SW","75", IF($K2="A","01", IF($K2="LI", "20",
> > IF($K2="F", "60")))))
> >
> > childofthe1980s
>
>
>

[Bob Phillips]

=IF($K2="HW","70", IF($K2="SW","75", IF($K2="A","01", IF($K2="LI", "20",
IF($K2="F", "60","you need to do something here when all else fails)))))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"childothe1980s" <[email protected]> wrote in message
news:[email protected]...
> I really don't know what you mean. Could you please explain?
>
> childofthe1980s
>
> "Niek Otten" wrote:
>
> > <IF($K2="F", "60")))))>
> >
> > And what if $K2 not equals "F"?
> >
> > Your formula is not complete
> >
> > --
> > Kind regards,
> >
> > Niek Otten
> >
> >
> > "childothe1980s" <[email protected]> wrote in
message
> > news:[email protected]...
> > > Hello:
> > >
> > > I'm trying to get a very simple nested IF, THEN statement to work.
But,
> > > instead of returning a value, it returns "FALSE". I really don't get
it.
> > > Below is my formula. Please help!!!
> > >
> > > =IF($K2="HW","70", IF($K2="SW","75", IF($K2="A","01", IF($K2="LI",
"20",
> > > IF($K2="F", "60")))))
> > >
> > > childofthe1980s
> >
> >
> >