Excel Formulae

R

rajash

Hi,

I have a spreadsheet with value in one column & a series of dates in 5
other columns.For each row depending on the value
in the first colunm a date may be applicable in one or more of the
other columns.e.g 550 in the first column will mean dates will be
inserted in the next 2 columns similar to authority levels. My qn. is
how can I show what's outstanding if the relevant authority levels have
not signed off-basically this is used as a tracker of invoices & I
would like to show what is outstanding awaiting approval at anytime.

Thanks

Raj
 
J

J.E. McGimpsey

I'm certain that this makes perfect sense to you. I've read this
half a dozen times, however, and I'm still not even close to
understanding what you're after.

Please post back with significantly more detail - for instance,
don't assume that readers know what "authority levels" mean to you,
much less which of them are relevant. What does 550 have to do with
2 of 5 columns having dates? What would 274.3 mean? or -2?
 
R

rajash

Hi,

Let me explain myself further: The spreadsheet is an invoice tracker
comprising of a column for invoice values for individuals with dates
went sent & received back.I would like to determine what is outstanding
at any point in time ie which invoices have not been signed off ie
those have no received back date.The matter is further complicated by
authority levels ie if the invoice is for 1500 then it has to pass
through 2 authority levels ie there have to be a date entry in 2
columns to be considered approved.

Hope this helps.Look forward to responses.

Rajash
 
Top