need help with excel formula
hi
i need help in creating formula
lets suppose a cell A6 have a date in it. and cell A7 have some number
in cell A8 i want to insert a formula that tell me if A6 have previous date and A7 is empty then A8 show "argent" in red color. if A7 have number then it shows "paid"
if date is today and the A7 is empty then A8 show "Due Today". if A7 have a number then "paid"
if the date is in future then then it shows "due Later"
Thank you
Need help with logical formula
I'm setting up a spread sheet for emergency on call personel. The problem is this:
Any dial-in and remote service within a (2) two hour period can only be charged one time during that two hour window.
EXAMPLE: If you dial or receive a request for service remotely @ 1:00PM and receive an additional request prior to 3:00PM you will only receive the two hour compensation. In addition, if you are required to travel to the site you are granted a (4) four hour minimum and if you respond to multiple request within that 4 hour window you will only be compensated for the four hours unless your time working extends beyond the 4 hour period.
I hope that wasn't too confusing. So, in a column for hours I need to make sure that all of the above is calculated properly so that the time is not allowed to overlap, and if the work takes longer than 4 hours on a 4 hour minumum it can still be entered.
I would appreciate any and all help with this. This formula is way over my head.
Formula & Conditional Formatting
Qazinomi, Please try the formula below:
=IF(AND(A6Use conditional formatting to set the font colour for cell A8 to Red when it is equal to Argent.
i.e.
Use $A$8 = "Argent"
Then the font colour to red
Give it a try, I believe it will work.
Cheers,
Bangu.
Assuming Cell C5 contains
Assuming Cell C5 contains current date...your formula will be....
=IF(A6>C5,"due later",IF(A7<>"","Paid",IF(A6To get the current date using formula...
=DATE(YEAR(NOW()),MONTH(NOW()),DAY(NOW()))
Either you can put this date formula in cell C5 or replace C5 with this formula in the main formula itself.