# calculations

1. ### Cell Temp Variable

I have a complex cell function of the form: =if(iserr(complex_thing), error_message, complex_thing) Is there a way to avoid the function performing the "complex_thing" twice? Is Excel's internal processing smart enough to pick up on this? Ideally, I would like to use a temp variable such...
2. ### Division of existing fields to create new field

Hi Im new to Access and am now very stuck so any help would be fantastic. i have put the following into the zoom box of an empty field of my query Profit %: [profitvalbase]/[costvalbase] this returns a "this expression is typed incorrectly or is too complex" message however and both are...
3. ### formula to work out marks needed please !

At college we are designing a system which will allow teachers to enter marks into a sheet for each unit. At the side of this table it displays how many marks the student is from getting to the next mark. =IF(W3=0,"",IF(W3>Boundaries!A33,"-",Boundaries!\$A\$33-'Unit 2'!W3)) this is what i have...
4. ### Estimation Formula Based on Available Data

Ok so say I have two columns: <table style="width: 373px; height: 178px;" border="0" cellpadding="0" cellspacing="0"><col style="width: 67pt;" width="89"> <col style="width: 48pt;" span="2" width="64"> <tbody><tr style="height: 15pt;" height="20"> <td style="height: 15pt; width: 67pt;"...
5. ### How to Package an Excel Worksheet Calculations into A Function?

Hi everyone, I need some serious help! ... so any help would be awesome ... :) I have an excell sheet that takes inputs (let's say A, B, C) for three cases (let's say 'baseline', 'low', 'high'). This sheet then does a bunch of calcs and produces ouputs (let's say X, Y, Z) for each of the...
6. ### removing special characters

Hey all, right now I have this excel calculation: =IF( ISERROR( SEARCH("&", A1) ), IF( ISERROR( SEARCH(" ", A1) ), A1, LEFT(A1,LOOKUP(2^15,FIND(" ",A1,ROW(INDIRECT("1:"&LEN(A1)))))-1)),SUBSTITUTE(A1,MID(A1,FIND(",",A1,1)+1,FIND("&",A1,1)-FIND(",",A1,1)),"")) This effectively converts the...
7. ### VLOOKUP intervals in Excel

This is the problem.... Federal income tax can be computed through a VLOOKUP table for an income (x) by usingFederal income tax can be computed through a VLOOKUP table for an income (x) by using theFederal income tax can be computed through a VLOOKUP table for an income (x) by using the...
8. ### Excel formula for Calculating Percentages for Overhead-Profit

Hi In this example, I want to be able to change in a spreadsheet the Overhead and Profit percentages to any number in the boxes. As you look at the simple math, using 10% for example only gives you 7.94% real, as you need to divide to come up with the true 10%. So, how would you write this...
9. ### calculating the growth rate

Hi, we have a table: Sheet 1 (called as Main) Column C contains date from 1st January 1994 till 31st December 2008. Saturdays, Sundays and some holidays would be missing in the range. Column D contains NAV of say, Fidelity Magellan for the relevant dates in Column A. Now, we want to calculate...
10. ### Number of Calculations/ Excel Crash

Hi All, Must say I'm starting to feel like an annoying child in a class who keeps putting their hand up but hoping you're able to help all the same... I've constructed a Sub which works fine (thanks to some help from guys on here). However, the amount of data it is capable of handling...

### 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.

### Which adblocker are you using?

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

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