View Single Post
  #3   Report Post  
JE McGimpsey
 
Posts: n/a
Default Need help with a formula

One way:

E1: =(A1-B1+C1-D1)

Format E1 as General or another number format

F1: =IF(E1<=6,"",E1*LOOKUP(E1,{7,11,31},{1,2,3}))

where 1,2,3 are your three different integers.

In article ,
"Bryan J Bloom" <Bryan J wrote:

I need to subtract 2 different sets of dates to get a total amount of days.
Eg: (a-b)+(c-d) = e
I then need to take the total (e) and multiply by 3 different integers if
the total (e) is greater than 6 days,10 days and 31days.
This helps me keep track how long my company trucks are out of a Rail/Ship
Yard.
I can't seem to get the dates to subtract and get an integer(regular
number). and I'm dead lost on the greater than stuff.
Of course the boss drops this on me on my first day.
Any help or comments will come highly appreciated.
Thank you