LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Todd F.
 
Posts: n/a
Default Add 2nd variable to if statement - ifAnd?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Statement lintan Excel Worksheet Functions 1 December 2nd 04 11:31 PM
Duplicate fields does not match up! If statement Patsy Excel Worksheet Functions 0 November 11th 04 12:16 AM
change function variable prompts?? thinkingfield Excel Worksheet Functions 1 November 8th 04 04:01 PM
If statement needed Patsy Excel Worksheet Functions 1 November 4th 04 03:48 PM
IF Statement difficulty susan hayes Excel Worksheet Functions 3 November 2nd 04 09:46 PM


All times are GMT +1. The time now is 07:07 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"