formula and format

  1. A

    Formula autofill skips reference cells

    Basically, I want autofill to skip reference columns at a static rate. I have the formula "=SUM('FPY Data'!K5:K54)-SUM('FPY Data'!L5:L54)" in column E. When I drag autofill across column F is "=SUM('FPY Data'!L5:L54)-SUM('FPY Data'!M5:M54)" but I want it to be "=SUM('FPY Data'!R5:R54)-SUM('FPY...
  2. B

    Formula that leaves cell blank until formula calculated

    What can I add to the following formula that will leave the cell blank until the formula is calculated - so this doesn't show as the result: #DIV/0! Simple formula: =(B17+C17)/E17 Formula is in cell H17 which I want to remain blank until the formula can be calculated, then the result of the...
    • blandreth
    • Thread
    • blank calculated formula formula and format formula and functions
    • Replies: 3
    • Forum: Excel Questions
  3. C

    Help please

    Hey guys (and girls), this is my first post XD... first off sorry if it's in the wrong place and second thanks in advance if anyone can help. =IF($A2=Items!$A$2,Items!$B$2,0) This is the base of my formula, as you can see i'm trying to see if "sheet As" A2 matchs "Sheets Bs" A2 and returning...
    • CyannideHigh
    • Thread
    • formula formula and format help excel formula simplification simplify if formula
    • Replies: 4
    • Forum: Excel Questions
  4. E

    Format Result from a Formula

    Hello, I would like to format a result with currency, no dollar sign, and zero decimals. Cell H2 is the cell in question. Formula: =CONCAT(H2," (",ROUND(I2,2)*100,"%)") Result: 222000 (40%) Preferred Result: 222,000 (40%) An advanced thank you for your time and support. It is truly...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top