| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Quick formula help please
Have I missed something here?
=IF(E130,"early",E13<0,"late") Cheers!! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Quick formula help please
=IF(E130,"Early",if(E13=0,"","late")
"Norm" wrote: Have I missed something here? =IF(E130,"early",E13<0,"late") Cheers!! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Quick formula help please
Thanks,
E13 is a time value.. if E13 has a value of 12:30 and early is before 12:00 and late is after 12:45 and 12:00 to 12:45 is On Time how would I formula this? Cheers!! "Norm" wrote: Have I missed something here? =IF(E130,"early",E13<0,"late") Cheers!! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Quick formula help please
On Wed, 19 May 2010 10:14:10 -0700, Norm
wrote: Have I missed something here? =IF(E130,"early",E13<0,"late") Cheers!! =if(e130,"early",if(e13<0,"late","on time")) --ron |
|
#5
|
|||
|
|||
Quote:
all the best
__________________
Thanks Bala |
|
#6
|
|||
|
|||
|
Quote:
istext verify whether content in e13 is numeric or text. all the best
__________________
Thanks Bala |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with a quick formula? | Excel Discussion (Misc queries) | |||
| Quick formula | Excel Discussion (Misc queries) | |||
| quick key to go to formula bar | New Users to Excel | |||
| I need help quick! Formula | Excel Worksheet Functions | |||
| Quick formula question | Excel Worksheet Functions | |||
Hybrid Mode
