AnsweredAssumed Answered

A Novice Nightmare

Question asked by KhaliMartin on Aug 8, 2014
Latest reply on Aug 11, 2014 by KhaliMartin

Title

A Novice Nightmare

Post

     Hi

     Can anyone help? I am quite new to this so the simpler the solution the better.

     I have 5 fields that can have a currency value: Costs A, Costs B, Costs C, Costs D, Costs E

     I also have a field called Total Other Costs.

     I am trying to populate another 5 fields so that

         
  1.           if Costs B to E are blank 100% of Total Other Costs is added to Costs A
  2.      
  3.           If Costs C to E are blank 50% of Total Other Costs is added to Costs A to Costs B
  4.      
  5.           if Costs D to E are blank 33.33% of Total Other Costs is added to Coast A to Costs C
  6.      
  7.           If Costs E is blank 25% of Total Other Costs is added to Cost A to D
  8.      
  9.           if Costs A to E are filled then 20% of Total Other Costs is added to all

      

     Many thanks in advance.

     Khali

Outcomes