Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
It has been a long while since doing big nested if's
I have supplied a lengthy question with actual values. I have the following formula: =IF(F36="",(((E31*$J$7)/52)*$J$8),(((E31*$J$7)/52)*F36)) F36 is an overirde number, if left blank then will execute with master number on top of page but if I enter number (override) to f36 then uses f36 instead of master number in j8. The 2ND and new override is a whole number that if placed in cell H36 will replace the following portion of the formula: ((E31*$J$7)/52) - this yields 511 F36 = €śblank€ť (for this example) E31= 1300 $J$7=20.5 $J$8=18 I am overriding a 1 week budget of 511 with a number like 470 for example with my overall goal to keep the original formula intack because it changes and then add this new variable over top of it. Hey thanks for your suggestions and time and have a happy holiday. Todd Frisch |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Statement | Excel Worksheet Functions | |||
Duplicate fields does not match up! If statement | Excel Worksheet Functions | |||
change function variable prompts?? | Excel Worksheet Functions | |||
If statement needed | Excel Worksheet Functions | |||
IF Statement difficulty | Excel Worksheet Functions |