Function possible?

[EM]

I need a weird function for my excel-sheet.

A1=B1 * 0.016 , but I need it to say in A1 'Not Payable', if the B1 is less
than 10 ?....

Is it even possible?

-confused Erin, struggling with a course project-

[Niek Otten]

In A1:

=IF(B1<10,"Not Payable",B1*0.016)

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"EM" <em64@suomi24.fi> wrote in message
news:ctpsaf$jr4$1@nyytiset.pp.htv.fi...
>I need a weird function for my excel-sheet.
>
> A1=B1 * 0.016 , but I need it to say in A1 'Not Payable', if the B1 is
> less
> than 10 ?....
>
> Is it even possible?
>
> -confused Erin, struggling with a course project-
>
>

[EM]

Thanks!!!

U made my day!

-erin-






"Niek Otten" <nicolaus@xs4all.nl> kirjoitti
viestissä:umzfkQPCFHA.3092@TK2MSFTNGP10.phx.gbl...
> In A1:
>
> =IF(B1<10,"Not Payable",B1*0.016)
>
> --
>
> Kind Regards,
>
> Niek Otten
>
> Microsoft MVP - Excel
>
> "EM" <em64@suomi24.fi> wrote in message
> news:ctpsaf$jr4$1@nyytiset.pp.htv.fi...
> >I need a weird function for my excel-sheet.
> >
> > A1=B1 * 0.016 , but I need it to say in A1 'Not Payable', if the B1 is
> > less
> > than 10 ?....
> >
> > Is it even possible?
> >
> > -confused Erin, struggling with a course project-
> >
> >
>
>