Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF function
I have an if function that relies on dates... the formula works every time
unless the value is = 0 .. then it displays -1.13687E-13 as the value... how can i fix this?!?! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF function
What is your formula? And when the value is zero, what value are you
referring to? -- John C "Rebecca" wrote: I have an if function that relies on dates... the formula works every time unless the value is = 0 .. then it displays -1.13687E-13 as the value... how can i fix this?!?! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF function
You can "nest" IF functions, so you could skip the current IF by
checking for 0. Assuming that your date is in A5: =IF(A5=0,"",[current if]) The "" piece inserts a null string if the test is true (which serves to make the cell appear empty) - and note that there are 2 double quotes in there and not 4 apostrophes. On Jul 29, 11:03*am, John C <johnc@stateofdenial wrote: What is your formula? And when the value is zero, what value are you referring to? -- John C "Rebecca" wrote: I have an if function that relies on dates... the formula works every time unless the value is = 0 .. then it displays -1.13687E-13 as the value.... how can i fix this?!?! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF function
OK, Rebecca, now you've got us interested. Is the next phase of the game
the one where we have to guess what your formula might be, or are you going to give us a clue? :-) -- David Biddulph "Rebecca" wrote in message ... I have an if function that relies on dates... the formula works every time unless the value is = 0 .. then it displays -1.13687E-13 as the value... how can i fix this?!?! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF function
Or, to put it another way, =IF(ABS(your_formula)<1.2E-13,42,your_formula)
:-) -- David Biddulph "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... OK, Rebecca, now you've got us interested. Is the next phase of the game the one where we have to guess what your formula might be, or are you going to give us a clue? :-) -- David Biddulph "Rebecca" wrote in message ... I have an if function that relies on dates... the formula works every time unless the value is = 0 .. then it displays -1.13687E-13 as the value... how can i fix this?!?! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ISBLANK function not working when cell is blank dut to function re | Excel Discussion (Misc queries) | |||
copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions |