Home |
Search |
Today's Posts |
#6
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() Good Afternoon - I'm not sure if this helps, but I found another way to express my attempted formula. All to occur in cell G2 Condition 1. If F2 is 0 then multiply F2 by D2. Condition 2 in the same cell. If the product of F2 multiplied by D2 is E2 AND the sum of F2 and F1 multiplied by D2 is 0, then add the product of D2 multiplied by the sum of F1 and F2 to E2, otherwise input E2 Condition 3 in the same cell. If the product of F2 multiplied D2 is < E2 BUT the sum of F2 and F1 multiplied by D2 is 0, then input the product of D2 multiplied by the sum of F1 and F2. Condition 4 in the same cell. If F2 < 0, and the sum of sum of F2 and F1 multiplied by D2 is < 0, then 0. Derek -- derekblain ------------------------------------------------------------------------ derekblain's Profile: http://www.excelforum.com/member.php...o&userid=37171 View this thread: http://www.excelforum.com/showthread...hreadid=568877 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Seat Plan | New Users to Excel | |||
Formula to figure bonus | Excel Worksheet Functions | |||
formula for bonus or penalty | New Users to Excel | |||
calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
AGE CALCULATING EXCEL SPREADSHEETS AND OTHERS! | Excel Discussion (Misc queries) |