 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / October 20062.5-0.89¢-#VALUE!-2.5 - =IF((F3/ H3)>0,TEXT(F3/H3,"$0.00") No wo rk
cells at are: 2.5 = f3 / 0.89 = H3.. #value! should be: 0.36 =IF((F3/H3)>0.99,TEXT(F3/H3,"$0.00"),TEXT(F3/H3,"0.00¢")) On another line with same formula: this works 8.3 $1.39 0.17¢ The only thing I can tell is that the second column is not less then $1.00 Please help me with this... thank you. Is it possible that you have something else in F3 or H3 besides numeric values? Also, if the ratio is < 0.99, do you really want to have it listed as 0.00 CENTS? Your result will be 2 orders of magnitude smaller than what it is. > cells at are: > 2.5 = f3 / 0.89 = H3.. #value! should be: 0.36 [quoted text clipped - 8 lines] > > Please help me with this... thank you. Why not just use a custom format (Right Click -> Format Cell -> Number -> Custom) for the cell something like this... [>0.99] $0.00; 0.00¢ Now just use the formula F3/H3 in the cell and it will format the way you intend... The only difference being that your formula is returning text and not a number but I should think you want the value to be a number anyways.  SignatureHTH... Jim Thomlinson > cells at are: > 2.5 = f3 / 0.89 = H3.. #value! should be: 0.36 [quoted text clipped - 8 lines] > > Please help me with this... thank you. > Why not just use a custom format (Right Click -> Format Cell -> Number -> > Custom) for the cell something like this... [quoted text clipped - 4 lines] > intend... The only difference being that your formula is returning text and > not a number but I should think you want the value to be a number anyways. Jim, that's cause I'm not smart enough to figure that out yet..:) However, its cleaner, and I do want the Dollar symbols to be added as text because its not imported into a package I have to do labels... > > cells at are: > > 2.5 = f3 / 0.89 = H3.. #value! should be: 0.36 [quoted text clipped - 8 lines] > > > > Please help me with this... thank you. > cells at are: > 2.5 = f3 / 0.89 = H3.. #value! should be: 0.36 [quoted text clipped - 8 lines] > > Please help me with this... thank you. ******* Figured it out, the problem is: I was using the Text converted version to do my calculations instead of the intger version of it. dividing f3 as text .. Doh I assume that you've got the F3 & H3 back to front in your question? If you're expecting F3/H3 to be 0.36, then the 0.89 must be in F3 and the 2.5 in H3. With those numbers, your formula gives 0.36¢. If you're getting #VALUE as an answer, then I assume that one or both of the numbers isn't actually a number, but text. Change it to a number. SignatureDavid Biddulph > cells at are: > 2.5 = f3 / 0.89 = H3.. #value! should be: 0.36 [quoted text clipped - 8 lines] > > Please help me with this... thank you. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.