Function possible?

E

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-
 
N

Niek Otten

In A1:

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

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
Top