Function possible?

  • Thread starter Thread starter EM
  • Start date Start date
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-
 
In A1:

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

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If Function for Text 1
Copying functions without changing most variables in it 3
EXCEL FORMULA 2
Cell Merging 1
help with formula 1
Excel Repeating a RAND() function under certain conditions 0
Trying to calculate results in one cell, based on data of another 9
Building closed workbook file path within an Index Function 6

Back
Top