Forum

Hi Hans, I couldn't execute your code as-is because it's not complete - I don't have the variables you are using set to any values. But if I jus...

Hi Dorsa, You start working out the factorial using an uninitialized variable 'Factorial' which has a default value of 0. So your function result ...

Hi Aye, I'm sorry but we have to impose some restriction on the size of files uploaded to the site. We don't have unlimited storage space. You ...

Hi Maurizio, Firstly, please don't tun off error handling with ON ERROR RESUME NEXT without using your own error handlers. I think I've mentioned t...

Hi Mehdi, SUBSTITUTE allows you to: 1.Replace all occurrences of a substring in a string 2. Replace a particular instance of a substring wit...

You're welcome.

Hi, What have you tried that doesn't work? Please supply the workbook and code. What version of Windows are you using? Regards Phil

Hi Bhavesh, So what is it you actually want to do, you haven't really explained? Change $Z$54 to some other cell reference? Please supply the w...

Please supply a workbook with sample data and examples of your expected outcomes, and cover all scenarios. Thanks Phil

No worries - see attached. P

Hi Candid, try this attachment. The values for the bands (1M, 20M etc) are hardcoded into the formulae. So you should replace these with cell r...

Hi Candid, This is why it's always best to include a workbook and several examples of the desired outcomes. So to make sure we are clear, do you...

Hi Candid You should read about nested IF statements =IF(A2<=1000000,0.055,IF(A2<=20000000,0.03,IF(A2<=30000000,0.025,0.01))) Work...

Hi Andi, Not sure how you can change a cell, but at the same time not change the cell. Why do you want to do this? If you can explain your inten...

Your data validation formula could be =EXACT(B2,VLOOKUP(B2,E2:E6,1)) with the cell you are typing into being B2 and the permitted list of inputs...