Getting multiple IF statements to work

[Psycho0426]

I'm trying to automate a few features on our billing invoices, and for the life of me, I cannot get my formula to work out right. I'm trying to get a cell to look at the date in a certain cell and based on how many days old it is, display one of four results (Current, 30+, 60+, & 90+). The formula I'm trying is below:

= IF (L16<=30),"Current",IF (L16<=60),"30+",,IF (L16<=90),"60+",IF(L16>90),"90+"

To my eye, this looks correct, but somethings wrong.

[Dave Peterson]

Watch your parentheses:

=IF(L16<=30,"Current",IF(L16<=60,"30+",IF(L16<=90,"60+",IF(L16>90,"90+"))))



Psycho0426 wrote:
>
> I'm trying to automate a few features on our billing invoices, and for
> the life of me, I cannot get my formula to work out right. I'm trying
> to get a cell to look at the date in a certain cell and based on how
> many days old it is, display one of four results (Current, 30+, 60+, &
> 90+). The formula I'm trying is below:
>
> = IF (L16<=30),"Current",IF (L16<=60),"30+",,IF
> (L16<=90),"60+",IF(L16>90),"90+"
>
> To my eye, this looks correct, but somethings wrong.
>
> --
> Psycho0426
>
> ------------------------------------------------------------------------
> Psycho0426's Profile: http://www.excelforum.com/member.php...o&userid=32832
> View this thread: http://www.excelforum.com/showthread...hreadid=570589

--

Dave Peterson

[paul]

you also have two commas after 30+,, should only be one

--paul
paul.shepherd@nospamparadise.net.nz
remove nospam for email addy!



"Dave Peterson" wrote:

> Watch your parentheses:
>
> =IF(L16<=30,"Current",IF(L16<=60,"30+",IF(L16<=90,"60+",IF(L16>90,"90+"))))
>
>
>
> Psycho0426 wrote:
> >
> > I'm trying to automate a few features on our billing invoices, and for
> > the life of me, I cannot get my formula to work out right. I'm trying
> > to get a cell to look at the date in a certain cell and based on how
> > many days old it is, display one of four results (Current, 30+, 60+, &
> > 90+). The formula I'm trying is below:
> >
> > = IF (L16<=30),"Current",IF (L16<=60),"30+",,IF
> > (L16<=90),"60+",IF(L16>90),"90+"
> >
> > To my eye, this looks correct, but somethings wrong.
> >
> > --
> > Psycho0426
> >
> > ------------------------------------------------------------------------
> > Psycho0426's Profile: http://www.excelforum.com/member.php...o&userid=32832
> > View this thread: http://www.excelforum.com/showthread...hreadid=570589
>
> --
>
> Dave Peterson
>

[Psycho0426]

Ok, at least the formula gives a result now, but it's not figuring correct. I attached to this message a zip of the invoice I'm working on. The cells I'm trying to get to work are E16 through E32. Help me please, before I pull all my hair out...

[Dave Peterson]

Lots of people, including me, don't connect through excelforum.

And lots of people, including me, wouldn't open the file anyway.

If you don't get a response, you may want to post your problem in plain text.

Psycho0426 wrote:
>
> Ok, at least the formula gives a result now, but it's not figuring
> correct. I attached to this message a zip of the invoice I'm working
> on. Help me please, before I pull all my hair out...
>
> +-------------------------------------------------------------------+
> |Filename: AR-Blank.zip |
> |Download: http://www.excelforum.com/attachment.php?postid=5179 |
> +-------------------------------------------------------------------+
>
> --
> Psycho0426
>
> ------------------------------------------------------------------------
> Psycho0426's Profile: http://www.excelforum.com/member.php...o&userid=32832
> View this thread: http://www.excelforum.com/showthread...hreadid=570589

--

Dave Peterson

[pikapika13]

Not that we dont' trust you..but no one opens files...
What is in L16? A date?

Then use this:
=IF(TODAY()-L16<=30,"Current",IF(TODAY()-L16<=60,"30+",IF(TODAY()-L16<=90, "60+",IF(TODAY()-L16>90,"90+"))))

[cynthialam06]

IF(or(K2="AAP"),(K2),(k2="KG",(K2)),"")
I am trying to set a formula to enter a text based on if conditions. For example, if k2 is equal to aap, then enter aap or if k2 is equal to kg then enter kg if not then enter blank. Please help! Thanks

[shg]

Welcome to the forum.

Please take a few minutes to read the forum rules, and then start your own thread.

Thanks.