scheme

  1. U

    Can I set a maximum value on top of and IF sum?

    Hi All So I am using the following formula to calculate payment entitlements: =IF(L145="Scheme A",P145*30,P145*60) So Scheme A pays £30 per day and Scheme B pays £60 a day (in the above if Column L contains "Scheme A" it multiplies P by 30, if L doesn't contain "Scheme A" then P by 60) . This...
  2. P

    Restructuring data into a table format

    Hi everyone <o:p></o:p> <o:p></o:p> I have a large spreadsheet containing data around different schemes. Each scheme has a number of phases up to phase 7 and text is added around the status of each phase. <o:p></o:p> <o:p></o:p> I would like to change the structure of this data so that it is in...
  3. P

    Generating a list from a dyamic array

    Hi everyone <o:p></o:p> <o:p> </o:p> I would like to generate a list which calculates the largestshortfalls out of a variety of projects. Shortfall is defined as Revenue minusCost. <o:p></o:p> <o:p> </o:p> I would like the formulas to allow you to select a specificfunction from which to assess...
  4. C

    Sets and Rep Database to Template

    <tbody> Power 4x1 4x2 4x3 4x4 4x5 </tbody> POWER <tbody> SETS REPS WT. SETS REPS WT. SETS REPS WT. 1 x5 1 x5 1 x5 1 x3 1 x3 1 x3 1 x2 1 x2 1 x2 4 x1 4 x1 4 x1 </tbody> So this is...

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