Forum

Hi Cally, If you want the 3 separate calculations they will individually look a little different to the initial formula, because some of the logic ...

Hi Cally, If your value is in B2 =IF(B2<150000,B2*0.025,150000*0.025)+IF(B2>150000,IF(B2>500000,(350000*0.01)+(B2-500000)*0.005,(B2-150...

No worries 🙂

Hi Josias, It's a bit confusing because your initial post, subsequent post and attached workbook don't all agree. For example, you don't have a Sh...

Hi Gary, Can you attach your workbook please so we don't have to type in your data. Thanks Phil

EDIT: Velouria posted while I was looking at the workbook 🙂 Hi John, On the 'Schedule 2020' sheet, cell E10 is part of the header row for ...

Hi Craig, That's an image of your spreadsheet, not the spreadsheet. Phil

Hi Salim, Maybe rearranging your data so that it is in a format that will work with the functions in Excel is a better solution than requiring a co...

Hi Salim, Isn't this the same problem I answered here Regards Phil

Hi Audrian, Glad you got it sorted out. If there are 2 tables with the same id then the HTML is invalid/incorrectly written. An id should be uni...

Hi Salim, Please always start a new topic for each new question. You can use VLOOKUP to solve this - see attached. Regards Phil

Hi John, Please provide your workbook when asking a qs like this. I can't look at the code modules or the sheet contents to answer you properly. ...

You're welcome.

Hi Audrian, You need to let me now what line is generating that error. What line is highlighted in yellow in the debugger? I'd guess that the V...