Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need help with a formula
I am working on a timesheet. I have a dropdown list (Cell W8) wit categories of time, a cell with manual hours (Cell M8) and a cell wit converted hours (Cell L8) (formula =(K8-INT(K8))*24). I want to use formula to show if Cell W8 = General and Cell L8 is less than or equa to Cell M8 to perform an action. Here's my formula. If Range("W8").Value = "General" And Range("L8").Value < Range("M8").Value Then Range("w8").Interior.ColorIndex = 46 MsgBox ("Adjust numbers for time off or change the type to General or Holiday, then recalculate.") Range("o35").Value = "Error Alert! Please review and recalculat timesheet" I can get the formula to recognize less than and greater than, but i it's equal to it still performs as if it's less than. Can you help -- htmldiv ----------------------------------------------------------------------- htmldiva's Profile: http://www.excelforum.com/member.php...fo&userid=1941 View this thread: http://www.excelforum.com/showthread.php?threadid=38802 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Commenting custom formula fields/formula on formula editor | Excel Programming |