| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
help with a function
i am trying to work out a formula to:
calculate a cell but only if another cell is of greater value than another,(if not then value in cell = 0) then if the value is greater and the date is under 365 days calculates at %50 rate and if its over, calculate at %25 rate. can i do this from one cell/one formula. |
|
#2
|
|||
|
|||
|
Perhaps something like:
IF(A1B1,IF(B1365,B1*0.25,B1*0.5),0) Per Erik On Fri, 6 May 2005 21:46:01 -0700, Joe wrote: i am trying to work out a formula to: calculate a cell but only if another cell is of greater value than another,(if not then value in cell = 0) then if the value is greater and the date is under 365 days calculates at %50 rate and if its over, calculate at %25 rate. can i do this from one cell/one formula. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| clock | Excel Worksheet Functions | |||
| Function Won't Calculate -- Sometimes | Excel Discussion (Misc queries) | |||
| Need a ISWorkday Function -- Any Ideas | Excel Worksheet Functions | |||
| Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
| Conversion | Excel Worksheet Functions | |||
Linear Mode
