nominal

Hi, I am trying to work out a formula that written out looks like this Find 8th March in this table array and if the value is £4.08 return the nominal code in column B. Can someone help with the formula for this please. Thank you

Hi all, ive designed a spreadsheet for my accounting and im after a little help if anyone can please. within my sheet i have created a column with a drop down containing all the nominal codes. on sheet 2 which is my working sheet for formulas, i have the full list of codes. now, if a code is...

Hi, I need a formula to calculate a daily compound interest rate where I know the initial value and the present value. For example, if in a week an investment increased by 30% (let's say $100 becomes $130), how would I display the daily compound interest, ie by what percent did it increase each...

Hi all, I have hit a dead end and am in need of some help. Apologies in advance as this scenario is slightly lengthy I want to ensure that you all have the full information. The data that comes out of the accounting system is raw data dumps from 2 SQL data tables, one gives me all the purchase...