CHANGE FORMULA (IF FUNCTION)

almouchie

Board Regular
Joined
Dec 23, 2004
Messages
128
Book2
ABCDEFG
1SEQCMPUTERSIDDATEINDATEOUTCOMPUTERSBILLEDNoofCOMPUTERSDAYS
21T11/2/20051/10/200558
32M21/3/20051/10/2005ToConsider7
43M31/5/20051/10/200545
54C41/5/20051/10/2005BILLEDDate1
65T51/9/20051/10/20051/10/2005 
76M61/10/20051/14/2005
87G71/11/20051/14/2005
98I81/12/20051/14/2005
109M91/13/20051/14/2005
1110X101/13/20051/14/2005
Sheet1



HOW CAN I CHANGE THE FORMULAR IN G2 SO AS TO CONSIDER THE COMPUTERS THAT CAME IN THE LATEST NOT EARLIEST (FROM THOSE WITH SAME DATE OUT AS INVOICE)
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

ken2step

Well-known Member
Joined
Jan 9, 2003
Messages
632
I don't understand what your looking for here....the formula in Cell G2 has too many arguments for the IF statement for one so I can not tell what your are looking for.
Also your Large function is subtracting a date from an array of dates?????
More info is needed because I can't seem to read between the lines here. I really want to help you.
 

almouchie

Board Regular
Joined
Dec 23, 2004
Messages
128
basically that what i want -
formula whereby it calcualte the days between an invoice date & the dates in for only the computers that left (date out) on same day as day in. & when i filled column F with Billed or anything else so formula can ignore this computer becoz it was billed b4 & doesnt calculate it.
MY PROBLEM is to change formula to consider & calculate the Latest( not earliest) dates in that left same date as invoice.

Is it clearer?
 

Forum statistics

Threads
1,147,622
Messages
5,742,199
Members
423,711
Latest member
luisfreitas

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top