Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function needed????
I need a function that will help me add to any cell that doesn't reach the disired amount. If the required number is 14 and a calculated cell comes up with 13 or less; I need a funtion to take that number and add a penalty number to it. For example: For arguements sake the penalty is $150.00. Suppose cell 1A has 5 and cell 1B has 5; cell 1C adds them for a total of 10. I need cell 1D to realize that the number in 1C did not equate to atleast 14 and therfore 1D should show $150.00 and for every cell selected that falls short of 14 should add an additional $150.00 to 1D. -- prbucci ------------------------------------------------------------------------ prbucci's Profile: http://www.excelforum.com/member.php...o&userid=30428 View this thread: http://www.excelforum.com/showthread...hreadid=501425 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
DAverage Function help needed | Excel Worksheet Functions | |||
Desperate Help needed with a function. | Excel Worksheet Functions | |||
function needed | Excel Worksheet Functions | |||
IF function help needed | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |