Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
In E17 I placed =If(isblank(A17),"===",B17-C17)
In A17 I have the date 4/4/05 In B17 is the negative number -30.33 In C17 is the number 0.00 In E17 I get 30.33 instead of -30.33 How can I fix this to get -30.33 in E17 Also if A17 is blank/empty and B17 is empty and C17 is 500 then I get #VALUE! in E17 instead of === |
#2
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Your formula works correctly when values are keyed into A17 and B17 and C17.
What formulas do you have in those cells? -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "gudway" wrote in message ... In E17 I placed =If(isblank(A17),"===",B17-C17) In A17 I have the date 4/4/05 In B17 is the negative number -30.33 In C17 is the number 0.00 In E17 I get 30.33 instead of -30.33 How can I fix this to get -30.33 in E17 Also if A17 is blank/empty and B17 is empty and C17 is 500 then I get #VALUE! in E17 instead of === |
#3
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Perhaps the cells B17 and /or C17 are formatted as text - Format |
Cells | Number (tab) | General on both, then edit the contents of each cell (or press F2). Hope this helps. Pete |
#4
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Check the formatting in cell E17
Format, Cells, write down what you see, then select Custom and write down what you see change the format to General if you something in cell A17 and a text entry in B17 you would get a #VALUE! error try this F17: =ISNUMBER(B17) G17: =ISNUMBER(C17) if they are not numbers you might want to read the write-up at http://www.mvps.org/dmcritchie/excel/join.htm#trimall --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "gudway" wrote in message ... In E17 I placed =If(isblank(A17),"===",B17-C17) In A17 I have the date 4/4/05 In B17 is the negative number -30.33 In C17 is the number 0.00 In E17 I get 30.33 instead of -30.33 How can I fix this to get -30.33 in E17 Also if A17 is blank/empty and B17 is empty and C17 is 500 then I get #VALUE! in E17 instead of === |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
why a reference to an empty cell is not considered empty | Excel Discussion (Misc queries) | |||
Adding a row to worksheet does not update cell references in another. | Excel Worksheet Functions | |||
Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
Cell color based upon cell value | Excel Discussion (Misc queries) | |||
cell color index comparison | New Users to Excel |