| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
require a change in formula
Hi, I am currently using a formula =IF(I11<TIME(14,0,0),100%,0%) find the the % and whether the job is done before 14:00 problem is when i dont enter any data also it shows 100% which is affecting my chart. I need the formula to calculate only when i enter data in the relevant field. can any one help me in this issue. -- Sathisc ------------------------------------------------------------------------ Sathisc's Profile: http://www.thecodecage.com/forumz/member.php?userid=187 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=93305 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
require a change in formula
Try this:
=IF(AND(I11<"",I11<TIME(14,0,0)),100%,0%) -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Sathisc" wrote in message ... Hi, I am currently using a formula =IF(I11<TIME(14,0,0),100%,0%) find the the % and whether the job is done before 14:00 problem is when i dont enter any data also it shows 100% which is affecting my chart. I need the formula to calculate only when i enter data in the relevant field. can any one help me in this issue. -- Sathisc ------------------------------------------------------------------------ Sathisc's Profile: http://www.thecodecage.com/forumz/member.php?userid=187 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=93305 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
require a change in formula
Try it this way:
=if(i11="","",if(i11<time(14,0,0),100%,0%)) or, shorter: =if(i11="","",if(i11<--"14:00",1,0)) Regards, Fred. "Sathisc" wrote in message ... Hi, I am currently using a formula =IF(I11<TIME(14,0,0),100%,0%) find the the % and whether the job is done before 14:00 problem is when i dont enter any data also it shows 100% which is affecting my chart. I need the formula to calculate only when i enter data in the relevant field. can any one help me in this issue. -- Sathisc ------------------------------------------------------------------------ Sathisc's Profile: http://www.thecodecage.com/forumz/member.php?userid=187 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=93305 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
require a change in formula
Thanks guys -- Sathisc ------------------------------------------------------------------------ Sathisc's Profile: http://www.thecodecage.com/forumz/member.php?userid=187 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=93305 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
require a change in formula
Glad we could be of help! -- Pecoflyer Cheers - ------------------------------------------------------------------------ Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=93305 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Require a Formula to caluclate the date | Excel Discussion (Misc queries) | |||
| Excel Chart - Require a Formula | Excel Worksheet Functions | |||
| help is require with this | Excel Worksheet Functions | |||
| trying to create a formula and require help. | Excel Worksheet Functions | |||
| Does what I'm trying to do require programming? | Excel Discussion (Misc queries) | |||
![Sathisc[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
