Can You Translate This Function Into Excel Format?

I

iwgunter

I can write functions in PHP & MySQL, but can't get my headd aroun
another language for Excel.

I have a spreadsheet with 2 columns for dates (B & C), a duratio
column (D) and a Yes or No column (E). We fill column B with the date
car arrives at our workshop, C with the date it leaves, D with th
duration of time we had it and E if it has been added to the insuranc
database [if it is with us more than 14 days].

I need to work out the duration column with the following style o
function...

Code
 
H

hideki

for if statement, put like this in your cells D2
=IF(C2="",TODAY()-B2,C2-B2)

and for your conditional format

criteria1:
formula=AND(D2>14,E2="Yes")
set your pattern color to blue

criteria2:
value greater than 14
set your color to re
 
I

iwgunter

Cheers for the help guys. I have got it working now. I changed it aroun
a bit and now use...

Code
-------------------
=($C2<>"") - Fill Green
=($E2="Yes") - Fill Blue
=($D2>14) - Fill Re
-------------------

+-------------------------------------------------------------------
|Filename: ExcelMIDLog.GIF
|Download: http://www.excelforum.com/attachment.php?postid=3753
+-------------------------------------------------------------------
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top