Function possible?
 

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-

In A1:

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

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"EM" wrote in message
...
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-

Thanks!!!

U made my day!

-erin-






"Niek Otten" kirjoitti
...
In A1:

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

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"EM" wrote in message
...
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-