View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Excel learner Excel learner is offline
external usenet poster
 
Posts: 5
Default formulae for a warning if with in 20 % of a order value in excel

I am trying to put a spreadsheet together that will warn me if there is only
20 % left of an order value i.e the order value will be in the top cell and I
have got a invoiced to date where all the invoices are added up and then I
need to know the percentage left after whats been invoiced to date I hope
this makes sense to some1.,