| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Baffeling IF statement
I am stumped on this one, so simple yet....
a1=9:00 b1=9:30 c1= the time difference with the formula =B1-A1 (results =0:30) d1=0:30 (used as a reference or goal) e1 formula =IF(c1=D1,"Yes","No") In this case the answer is YES Now the hard part, if I change the cells to: b1=9:50, c1 showes 0:50 D1=0:50 e1 is now = NO it should be YES I tried test values of 0:49 and 0:51 by changing b1 d1 they work and say YES, only 0:50 minutes errors???? TX MIke |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup, if statement, maybe an and statement | Excel Discussion (Misc queries) | |||
| IF statement inside a SUMIF statement.... or alternative method | Excel Worksheet Functions | |||
| Reconcile Bank statement & Credit card statement & accounting data | Excel Worksheet Functions | |||
| Embedding an OR statement in an IF statement efficiently | Excel Discussion (Misc queries) | |||
| appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
Threaded Mode
