- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
Help in Excel (should be easy for your guys)
Posted on 8/18/20 at 5:48 pm
Posted on 8/18/20 at 5:48 pm
I'm having trouble with what seems to be a simple excel formula...
I have fields where I enter "Volume", "Current % Rate", and "Proposed % Rate" in one area of the workbook, that populates the entered values to another "Summary" area...
Currently, if you only put in the "Volume" and either of the % rates, it will show that value in the "Savings" column.
I need a formula that will effectively check to see if there's values in B4:D4, populate L4:O4 and do the calculation for the "Current" and "Proposed" % rates and then ultimately show the "Savings"...
*BUT*, if there's not all three values in the B4:D4 cells, if any of them is left empty or has a " 0 " then I need the "Savings" column to be left blank.
I've tried =COUNTIF, =IF(COUNTBLANK), etc. and can't seem to *NOT* include the "$0.00" value as null, thusly keeping anything from populating in the "Savings" column.
Any ideas?
I have fields where I enter "Volume", "Current % Rate", and "Proposed % Rate" in one area of the workbook, that populates the entered values to another "Summary" area...
Currently, if you only put in the "Volume" and either of the % rates, it will show that value in the "Savings" column.
I need a formula that will effectively check to see if there's values in B4:D4, populate L4:O4 and do the calculation for the "Current" and "Proposed" % rates and then ultimately show the "Savings"...
*BUT*, if there's not all three values in the B4:D4 cells, if any of them is left empty or has a " 0 " then I need the "Savings" column to be left blank.
I've tried =COUNTIF, =IF(COUNTBLANK), etc. and can't seem to *NOT* include the "$0.00" value as null, thusly keeping anything from populating in the "Savings" column.
Any ideas?
2
Posted on 8/18/20 at 6:14 pm to yankeeundercover
too late in the day for this one. I'll circle back tomorrow morning
Posted on 8/18/20 at 6:19 pm to big_tuna
Damn, you're killin me! I'm really trying to get this knocked out tonight.
I can't imagine it would be this hard to have several cells populate several others and then based on those values, spit out a total... and if the initial values are null, 0.00, or blank, etc. then nothing gets spit out.
I can't imagine it would be this hard to have several cells populate several others and then based on those values, spit out a total... and if the initial values are null, 0.00, or blank, etc. then nothing gets spit out.
Posted on 8/18/20 at 7:41 pm to yankeeundercover
Will the cells be null (blank), $0.00 or a combo of those in columns B:E.
Not exactly sure of your layout, but here's an example using your heading (somewhat). So if your columns are Volume (B), Current Rate (C), Proposed Rate (D) and then Savings (L). Then in column L the formula would be =if(and($B4>0,$C4>0,$D4>0),($b4*$c4)+($b4*$d4),"")
Not exactly sure of your layout, but here's an example using your heading (somewhat). So if your columns are Volume (B), Current Rate (C), Proposed Rate (D) and then Savings (L). Then in column L the formula would be =if(and($B4>0,$C4>0,$D4>0),($b4*$c4)+($b4*$d4),"")
This post was edited on 8/18/20 at 8:13 pm
Posted on 8/18/20 at 9:11 pm to r3lay3r
Took a little bit of tweaking for my current cell location, but that seems to have been exactly what I was looking for.
I've never used an "IF/AND" formula before...
Thank you, sir!
I've never used an "IF/AND" formula before...
Thank you, sir!
Page 1 of 1
Popular
Back to top
Follow TigerDroppings for LSU Football News