| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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- |
|
#2
|
|||
|
|||
|
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- |
|
#3
|
|||
|
|||
|
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- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Trim function doesn't clean out ASCII Code 160 (Space) | Excel Worksheet Functions | |||
| Formula to list unique values | Excel Worksheet Functions | |||
| I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
| Find a Function to use accross different worksheets | Excel Worksheet Functions | |||
| Counting Function Dilemma | Excel Worksheet Functions | |||
Linear Mode
