| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
If function
If A2 minus 40 is less than zero then display zero in A15, or if A2 minus 40 is greater than 40 then run multiply A2 by 40 and display that in A15.
-- Message posted via http://www.officekb.com |
|
#2
|
|||
|
|||
|
Put one of these in A15.
If you don't need to account for exactly zero: =IF(A2-40<0,0,A2*40) If you do need to account for exactly zero and want to just return zero in the cell, you might try something like: =IF(A2-40<=0,0,A2*40) tj "Mitch Perala via OfficeKB.com" wrote: If A2 minus 40 is less than zero then display zero in A15, or if A2 minus 40 is greater than 40 then run multiply A2 by 40 and display that in A15. -- Message posted via http://www.officekb.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 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 | |||
| change function variable prompts?? | Excel Worksheet Functions | |||
| Counting Function Dilemma | Excel Worksheet Functions | |||
Linear Mode
