Cap Calculated Amount
I've written a custom function that calculates commissions (as a %) based on three variables.
I wanted to know what code I can use to cap the amount of commission paid out to a specific % amount. Something like "as soon as X exceeds 3 times the amount of Y, payout 3 times Y as the maximum".
View Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
CAP Lock Via VBA
I have a spreadsheet that requires the user to use ALL CAPS when they fill it out. Is there a way to have VBA turn on the CAP Lock regardless of the persons keyboard setting? I have asked that the users use ALL CAPS but of course that leave a lot of room for error.
View Replies!
View Related
Initial Cap Formula
I have two cells A1 and B1 both text: I want the resulting C1 value to the A1&B1 but initial Cap Eg A1=george B1-smith C1 would = George Smith What formaula dow i need to put in C1 and thus be able to drag down the page to convert over 1000 rows
View Replies!
View Related
Caps To First Letter Cap..
I like the proper formula and find it handy, however do you know if there is a formula that would only keep the first letter in the cell at caps and reduce the rest to lower case, ie A1 = MY DOG IS WHITE proper(A1) = My Dog Is White what I want is only first letter caps = My dog is white. I'va had a decent look around but can't find anything that would do this?
View Replies!
View Related
Hlookup (look At The Dates In Row 2 On The Tab Marked “Cap Plan”)
inputting a formula that will look at the dates in row 2 on the tab marked “Cap Plan” on the sample sheet and then go to tab “Monthly Mode” and match the date and then take the percentages for each work type on that tab and put them in the percentage columns in the tab “Cap Plan” for the correct date. This document will be a rolling 52 week one so a simple = formula will not work.
View Replies!
View Related
Reference Cell & Add Amount If Positive & Subtract Amount If Negative
Im trying to set up an active running inventory sheet where: (A)the progressive daily sheet cells reference back to the corresponding master sheet cells fluctuating the master values, (B) the same progressive daily sheet cells reference back to a cummulative totals-cell based on whether I added or subtracted inventory. I want to make a copy of the blank "sheet 2" with all of the formulas and move it to the end of the workbook each day and enter new values which will reference back to the master sheet so that I can click on a date sheet and see an individual day's values or click on the master sheet to see the fluctuating inventory on-hand and the cummulative +/- totals of all days combined. I've got a couple hundred individual cells to reference. I've tried and tried but I can't make it work. Heres what I need to do: I need to reference individual cells from "sheet 2,3,etc" back to a corresponding cell in a master sheet. But I need the values in each cell in "sheet 2,3,ETC" to increase or decrease the corresponding cell values in the master sheet. For example: If the value in the master sheet B5 is 200. Then in sheet 2, I enter +50 in B5, I need the master sheet cell B5 to increase by 50 to 250. I also need a way to decrease the cell value in the master sheet B5 if I enter a negative value -50 in sheet 2 B5. I also want to know if I can reference the same cell values entered in "sheet 2,3,etc cell B5" back to totals columns C5 for adding inventory or D5 for subtracting inventory in the master sheet where the master totals columns would reflect cummulative totals added or subtracted. For example: if the value in sheet 2 B5 is +50, then the value in Master sheet C5 would add 50 to a progressive total. But if the value in sheet 2 B5 is -50 then the value in master sheet D5 would add -50 to a progressive total.
View Replies!
View Related
Calculated Items
I have a pivot table with a calculated item. The problem is that it shows data for all rows EVEN when there is no data there. So the pivot table is a lot longer that it needs to be. How do I get the pivot table to show only rows with data in it? Also, all of the fields DO NOT have checks beside "Show Items With No Data".
View Replies!
View Related
Insert Calculated Rows
I need to insert 2 calculated rows in a data table for each state, one is Direct +2%, and Contractor +2%. Ideally, I would like to copy down the field name above. Every record in the table has the same 2 Categories (Direct & Contractor) and 2 calculations need to be applied. There are ~ 50,000 records so copy insert is not an option. Can a macro be applied to do this ? Current StateCategoryCount New YorkDirect150 New YorkContractor75 BostonDirect200 BostonContractor125 Result StateCategory Count New YorkDirect 150 New YorkContractor 75 New YorkDirect +2%153 New YorkContractor +2%76.5 BostonDirect 200 BostonContractor 125 BostonDirect +2%204 BostonContractor +2%127.5
View Replies!
View Related
Reference Calculated Cell Value
to copy the calculated value of a cell to another worksheet. I tried =IF('Actual Hours'!D2="*"&"LR"&"*",'Actual Hours'!D2,"") which when copied down would return values with LR in them, however D2 is a calculated cell (='RAS SENT 2'!L2) so it returns a blank, and I dont want to just reference this other cell instead. Is there a way to return the value of a cell?
View Replies!
View Related
Time Difference To Be Calculated
Date OutTime OutDate InTime InTime Difference 01-03-099:0001-03-09NIL 02-03-09NIL02-03-09NIL 03-03-09NIL03-03-0910:002 day(s) 1 hours 00 mins 03-03-0911:1503-03-0918:000 day(s) 6 hours 45 mins 04-03-099:00NILNIL 05-03-09NILNILNIL 06-03-09NILNILNIL 07-03-09NIL07-03-0914:453 day(s) 5 hours 45 mi In Column E in want the time difference to be calculated as shown above.
View Replies!
View Related
How To Change A Calculated Cell To A Value
I am entering data for a month on one worksheet. The next month I change the date and reenter new data. I want another worksheet to record the data on a month to month basis, one month in one column, the other month in another column, to have year to date. Is there anyway to do this. Currently, I use an if statment =If(a1="January",b1), but I need to change these to values before I do the next month, and alter the formula to reflect the new month name)
View Replies!
View Related
Self Calculated For The Current Month
I am working on spreadsheet that calculates yearly totals. It is set up similar to this: Jan Feb Mar Apr May ETC. TOTAL Charge 123 123 123 Goal 223 223 223 223 Cash 111 111 111 % Coll. 50% 50% 50% The "goal" column is Self calculated for the current month (I.E. it's April, that goal is calculated) The "Charge, Cash, and % Collections" columns won't be fill in for April until its over. have it add Aprils "Goal" but not add "Mays" and so on... Doing this for the entire year.
View Replies!
View Related
Formatting With Calculated Values
Column 2 is a calculated value (a sum of several other columns). I cannot get the code to work. When I enter the same value in the field it works, but not when it is a calulated value. I know there must be a simple error in here somewhere... Private Sub Worksheet_Change(ByVal Target As Range) If Target.Count > 1 Then Exit Sub If Target.Column = 2 Then Select Case Target.Value Case Is > 382: Target.Offset(0, 0).Interior.ColorIndex = 3: Target.Offset(0, 0).Font.ColorIndex = 2 Case Is > 315: Target.Offset(0, 0).Interior.ColorIndex = 30: Target.Offset(0, 0).Font.ColorIndex = 2
View Replies!
View Related
Validation On A Calculated Cell
I am trying to input data validation on a calculated field. The calculated field (sum of 10 fields above it) must not total over 100%. I have used the following in the data validation menu: Allow: whole number. Data: less than or equal to 1 This doesnt seem to be working when I input values of a total greater to 100 from its input cells however, it does return an error if I manually input a number over 100%, then it gives me an error message. Edit - sample sheet attached.
View Replies!
View Related
Placing A Calculated Value Into A Cell
if its possible to place a value (the product of a formula) into a cell ie: Cell A1 = "a" Cell A2 = "b" I would like to be able to say: If A1="a" and A2="b", then place "Yes" into D1. I realize that =if(and(a1="a",a2="b"),"Yes",0) placed in D1 would give the same result, but I do not want to have a formula in D1, I simply want the characters "Yes" placed in there.
View Replies!
View Related
Find Last Calculated Value In Column Of Formulas
I've got a workbook that includes a Check Register worksheet. Column K of the Check Register worksheet has formulas that maintain a running current balance. So Column K has numbers (calculated) from K12 down to the last transaction (K461 is this instance). Cells K462 to K2000 contain formulas awaiting to be calculated. I've written a procedure to "Create New Year" and in the process, I want to capture the value of the last calculated value in Column K from the old year. I cobbled code from different websites and have come up with this code
View Replies!
View Related
Control Ranges Automatically Calculated
When you have a formula that contains calculations using other cells, the formula will recalculate every time that referenced cell is changed. In my attached spreadsheet in the June 2007 Worksheet, in Column C10+ I am calculating realtime pip values given a stream of data from a DDE server. The DDE server values are in the Data tab. For ease of use I have also added a manual setting as I am sure no one here has the DDE server in question. My problem is everytime the DDE server (Or manually as it may be) changes the data field, the values in Column C and F on the July 2007 WorkSheet get changed. I would like Column F to only calculate one time (At the time of entering the trade). And I would like Column C to Stop updating and use the last updated value once the corosponding cell in Column G has a field data "Closed". This is very important to me as if it keeps updating over time, then a couple weeks into trading, the pip values may have adjusted substancially giving incorrect $ values in other cells.
View Replies!
View Related
Create List Of Calculated Results
I have created a formula that returns 2 dates and the number of days that lie between those dates (less weekends).. eg. Friday 22/12/06 Monday 8/1/07 10 days What I would like to do, but can't work out how, is create a button (and a function or macro or whatever) that transfers that data to another sheet, adding to columns of previously calculated data.
View Replies!
View Related
Insert Value On One Sheet Based On Calculated Value
I run an action log based on one worksheet per project and a front summary sheet. It has 6 columns of which the final is complete Yes / Blank. Currently the summary sheet is hard coded to provide the countblank result in an outstanding column against each project. My problem is that everytime I add a new action I have to change the hard coded range on the summary sheet. I know I should be able automate this using VBA and .End xlup so that it always knows howmany rows have been used and can therefore calculate the countblank correctly.
View Replies!
View Related
Validate Result In A Calculated Cell
I've been struggling with this for a little while today and quite can't seem to figure it out. I have a range --- A6:A28 --- where a user will enter a percentage. The total should add up to a 100%, which is in cell A30. My understanding is that a need a worksheet_calculate function to tell users to revise their entries if the results in a cell A30 are either less than or more than 100%. This is the simple, non-working procedure I have now:
View Replies!
View Related
Inclusing Calculated Cells In SUM
It is a few years since I worked in the IT industry and used EXCEL a lot. I want to use (formula) SUM on a cell which 'sums' 3 other cells one of which has a the result of a formula but the result of that SUM is always 0 (zero). I am sure I can remember doing this in the past but cannot determine how it is done. eg. Cell Contents C10 1000 (value) C11 =A1*(A10/A20) (formula) C12 2000 (value) C13 =sum(C10:C12) What do I need to do so that (cell) C13 results in the correct value instead of 0 (zero)
View Replies!
View Related
Replace Contents Of Calculated Location
I used to write macros in 123 and compile and sell them. Now working in VBA I feel like a pre-schooler. I'm just trying to do a simple macro that will look at a cell (say D4) and evaluate the formulat there which might result ing a new location (like G10), and put a "Y" in G10, , then, after I enter a few more bits of information, it will, upon my keystroke (like CTRL-F) do it again, enter the "Y" in the new cell, whatever D4 says now. I know that this isn't hard--but I sure can't figure out how to do it!
View Replies!
View Related
Calculated Fields In Pivot Tables
My Pivot Table data section contains calculated fields and normal fields...both have sub and grand totals. The calculated items are correct but. the calculated field totals are incorrect. The normal field totals are correct. The calculated field totals are ... the True total multiplied by the number of items!
View Replies!
View Related
Add Calculated Item To Pivot Table
Attached is a worksheet example, of my beauty salon with 5 therapists. The input sheet - is the shhet into which I input data on a daily basis. Weekly inc - This sheet shows the total that each therapist made in apivot table based on the input. The week numbers are 1 to 52 (or 53) depending on each financial year (07/08, 08/09 etc). What I want to do is either have another pivot table or to add an calculated item to the weekly inc pivot table showing me how much commission each therapist took each week? This is to be done automatically by excel. This commission is calcluated by using the target comm figures - E.G. Leanne's target is £480 - so she has to earn £480 a week before getting a commission. So if in a week she earns £500 - she will get a commission on £20 (£500 - £480). The commission is 10%, so she will earn £2 that week.
View Replies!
View Related
Pivot Table Calculated Item Removal
I have cut down my problem to its simplest form - in the real world my spreadsheet is significantly more complex but the attached spreadsheet demonstrates it nicely! The data is straightforward. PT1 shows the data without a calculated item whilst PT2 is the same PT but with the addition of a calculated item for GP (i.e Sales - COS). Unfortunately adding this has resulting in the PT growing and adding "ilogical" combinations of data that didn't exist in the source data. In my current project I have "cheated" by using a helper column and filtering on this using the Worksheet_PivotTableUpdate event to hide the unwanted rows but surely there must be a way of removing them "properly". Another problem, and I guess this is just the way it is, is that my PT takes ages to calculate presumably becuase it is calculating this formula for every combination of values?
View Replies!
View Related
Sum Total Of Calculated Field In PivotTable
i have a database of monthly sales of a regional distributor and im using a pivot table to manipulate my data. i want to show only what account makes a positive sales for a specific product and i want to get the total number of accounts who have the positive sales. there are multiple entries in my database, the condition is if an account have positive sales of a specific product regardless on how many times the account bought the result should be 1 (meaning one buying account) i've tried to use a calculated field in my pivot table, i get the correct result per account but when it comes to grand total its not getting the sum of the total number of accounts. here is the sample of what i need to get.. you can see that there are multiple entries but it shows only 1 per account when it has at least 1 positive sales of a specific product and 0 if it hasn't any sales/negative... and for the total it adds the number of accounts to get the total number of buying accounts..
View Replies!
View Related
Sumif Function In Pivot Calculated Field?
I'm getting an error message in when I attempt to create a pivot table calculated field formula using the SUMIF function. My questions are (A) Can SUMIF be used in a pivot table calculated field and (B) If Yes, then why am I getting an error message? To expand more on my second question(B). My scenerio is as follows. I need to compute the Total Inventory Value (Quantity X Cost) of all our inventory that is aged over 60 days. I have a "Total Value" field that gives me the inventory value at a sku level. also have a "Days Since Last Receipt" (DSLR) field that gives the Days since the Inventory was last Received at a sku level. For Example: SKU A --Total Value=$100 -- DSLR=50 SKU B --Total Value=$75 -- DSLR =70 SKU C --Total Value=$40 -- DSLR =80 Using the above scenerio and example I tried to execute this calculated field formula: =SUMIF(DSLR,">60",Total Value). However I get an formula error message.
View Replies!
View Related
Retain Calculated Field Number Formatting
I use pivot tables extensively in my job. I have several spreadsheets that feed from acess database tables to build pivot tables. Besides the fields imported from Acess, I also create calculated fields. The problem is, for both the calculated fields and the imported fields, the number formatting does not stick. I know how to go to field settings, then to number, and change the customized format. The problem is, once I take that field out of the pivot table and bring another one with a different format (say, bring a field with currency format and take away one field with a percentage format) and then bring the original field back to the privot table, the number format is gone. This is really annoying since I work with dozens of fields, and it takes time to change the number settings every time I change fields on the pivot table, and the number of decimal places, etc. I stress that I know how to change the number formatting on fields, it's just that it excel does not remember it afterwards. I thought that maybe the formulas in excel might allow one to include the formating, but I have not been able to find if this is possible, and if so, how to do it. So, for example, the following formula for a calculated field: =IF(ISERROR(Contribution/'Block Hours'), "0", (Contribution/'Block Hours')) would be nice if the formula itself could include the number formating. I tried including something like , 0.00% at the end, but it does not work.
View Replies!
View Related
Calculated Weighted & Conditional Average
The attachment is only a small portion of the data I need to analyse, but is representative of the full set of data. What I am trying to do is calculate a weighted average of each of the chemicals shown by location and machine usage and also still be able to use the filter or sort funtions. I have created a sample calculation in cell F9 to further explain this calculation. I would like to be able to use the A-Z sorting icon in any of the columns, while still computing the weighted average of the respected chemicals. As it is now, the referenced cells just remain as the 6-7 cells above the calculation instead of the 6-7 cells that apply to the specific chemical at the location and machine (in this example - caustic at location1 on mch-03). For example, if I try to sort in column F, I'd still like to see my example calculation to reference the same values as it is now, calculating the same resulting 60.719.
View Replies!
View Related
MACRO: Make A Table Of Calculated Values
I have made spreadsheet that calculates my total cost of making ice cream mix based on ingredient costs of two variables (Van_Gal, and Choc_Gal), for example 550 gallons and 750 gallons respectively. The worksheet calculates the total cost of making the Vanilla Gallons and the Chocolate Gallons. I’m not a VBA or Macro wiz, and now I’d like to Make a macro that will allow me to make a “table” of calculated costs associated with different assumed Vani_Gal and Choc_Gal amounts and then print the values; and then go down a row and print the cost of another amount of Vani_Gal and Choc_Gals until some preset end has been reached. For example: Van_Gal; Choc_Gal;TOTOutput;avg cost 550; 750; 1300; $4,000.00; $3.08 600; 700; 1300; $4,250.00; $3.27 Let’s say that I want to know what the tot cost and avg cost per gallon for various combinations of Vanilla and Chocolate Mix from 550 V and 750 Choc for various combos and have it increase in iterations of 10 Gallons (i.e. 560 Van and 740 Choc); Maybe I'd use a " loop" that repeats calculations and prints them for different combinations of Van/choc until 800 Gals Van and 500 gal Choc. Once I have a table of values, I could sort it and find an optimal production level (with the Minimum avg cost). how to make a macro that can crank out a table like this?
View Replies!
View Related
PivotTable Calculated Field With IF Function/Formula
I have a PivotTable which shows the number of packs produced in a month. I created a calculated field which shows the number of vehicles needed to move these packs. The number of packs per vehicle is dependent on two criteria, the Pack Description and the Store. My calculated field, Shunts, is described as: =Packs / IF(Store ="Middlewich",IF('Pack desc' ="Tall",30,60),IF('Pack desc' ="Tall",26,52)) which represents the logic Middlewich & Tall = Packs / 30 Middlewich & other = Packs / 60 Other & tall = Packs / 26 Other & other = Packs / 52 However, it doesn't work! I know Calculated Fields can be difficult to work with, but this is crazy and I think I'm missing something obvious as I'm sure I've had IFs work like this before! I've attached my example, also showing the values I'd expect to see.
View Replies!
View Related
Using References In Pivot Table Calculated Fields Formula
Worksheet A contains two columns, that maps individual operations to their unitary cost: COLUMN 1 = a list of operations COLUMN 2 = the cost associated with each operation. I can do a vlookup on this worksheet to retrieve the cost of each individual operation. On another worksheet, I have a pivot table with a field that produces the sum of operations performed by type of operation, eg. operation 1 was performed 5 times operation 2 was performed 7 times operation 3 was performed 4 times I want to add a calculated field in the pivottable, that would output the total cost per operation. The formula for the calculated field in thepivot table would be = operation * vlookup("name of operation","range for lookup table",2,0) ... unfortunately, "references, names and arrays are not supported in pivottable formulas".
View Replies!
View Related
VLOOKUP Inconsistently Returns Formula Calculated Cells
I'm having a real problem with the Vlookup formula in that I have used it in a spreadsheet to search, using approximate, rather than exact values, several tables where I have inserted raw data with no calculations and it works fine. But with one crucial series of cells where I am trying to return results from columns of fields that are the results of calculations, it sometimes returns the correct result and other times returns an empty field with seemingly no consistency at all. I've been careful to make sure the data in the cells in the lookup column are in ascending order, as required. I've checked the formatting (all the lookup cells are numbers, no zeros with the thousands commas inserted, and all the return cells are currency with two zeros and the $sign) and the formatting is consistent. Does anyone have a clue whether the calculations in the cells might be the problem or if it might be something else and, whatever the case, how I can workaround the problem? I'm a relative novice with Excel. I'm using Version 2007 but I'm saving the file as an .xls.
View Replies!
View Related
Formula Automatically Calculated Based On The Numbers I Choose
Basically...here's what I'm trying to do... I have 7 numbers. The numbers are going to be grouped in threes. (Ex. 123,124,125,126,127,134,....) I want to assign column/range for each number... 1=A2:A100, 2=B2:B100, 3=C2:C100... So for 123 the formula would be... sumproduct(--(A2:A100>criteria),--(B2:B100>criteria),--(C2:C100>criteria)) It would be awesome to have the formula automatically calculated based on the numbers I choose.
View Replies!
View Related
Calculated Cell Values With Sum, Max Formula
I've got a sample spreadsheet that I'm trying to get the MAX from a Range of cells that only begin with "TMP". Problem is, if I use MAX or SUM to try to calculate the largest number (or a sum, just to test), it returns "0" for the caluculated range. If I Copy and Paste Values, the MAX or SUM formulas still don't work. Only if I edit the cell and hit the ENTER key will the Formula(s) work, for each cell in the range that I edit/ENTER. All cells are formatted the same (GENERAL), and I'm not working it into a VBA Macro (just yet).
View Replies!
View Related
Pivot Table, Calculated Item.... No Data, Still Creates A Row
I have a Pivot table. Layout: Rows: City, Restaurant, Cashflow Column: Date (Month/Year) DataField: $Amount "City" might be 7 cities "Restaurant" may be 32 restaurants, some in some cities; but not other "CashFlow" can be either "Revenue" or "Expense" The layout of the Pivot table is nice, only shows the Rows where a State, Restaurant, and CashFlow entry exists for at least one Date on that row. And there are no extraneous rows for combinations that don't exist. Now.... the trouble... I added a Calculated Item, "Profit" which = "Revenue" - "Expenses". Now, every possible combination of State and Restaurant appears in the pivot table displayed. Only the "Profit" (calculated item) is shown for the previously hidden rows; and of course it's "$0.00" since there are no "Revenue" or "Expense" entries. How can I get the Pivot table to not display the results of a Calculated Item row, when there are no entries otherwise for that row combination? Is there a way to condition the Calculated Item to not calculate if there are no data entries in the addends for a particular combination?
View Replies!
View Related
Ignoring Blank Cells/zero Calculated Values In Drop Down List
i have a list which is populated with data from another sheet.. if there is no data in the corresponding cell on the other sheet then the cell is blank.. i've tried using: =OFFSET($Z$2,0,0,MATCH(REPT("z",255),$Z:$Z)) but it doesn't see the blank cells as blank i.e. no data in them as they contain formula's.. (even although there are no values populated) - can anyone offer any help in relation to this???
View Replies!
View Related
Grand Total Of The Calculated Field Returns Wrong Results
i have a problem regarding calculated field.. i have data of sales of a distributor with all the accounts that he handles.. i want to get the total number of buying accounts for that distributor.. buying account is an account that bought a specific product for at least one time... even the account buy 2 or 3 times more for that specific product the account is considered as 1 buying account.. i want to use a pivot table so i can manipulate the data.. first i tried to add an additional field to my data and put the formula "if(norbo_val>0,1,0)" where norbo_val is the total sales less the rejects. it means if ever an account have positive sales the account is considered as a buying account for that specific product. my problem is that when that account bought the same product for 2 or more times it sums all the times an account bought for that specific product.. so i decide to remove the field in my data and create a calculated field in the pivot table. i input the same formula to the calculated field and it gives me the correct result where if ever an account bought a specific product for at least one time regardless on how many times the account bought that same product, the account is considered as 1 buying account. the only problem i am encountering now is that the grand total is not summing up the total numbers of buying accounts if i list all the accounts. it seems the formula is affecting the grand total where it should add the total of buying accounts but instead using the formula of the calculated field so the result is only 1.
View Replies!
View Related
Bill Payment Calendar Should All Be Automatically Calculated Under The “Date” Column
When a date is entered e.g 1/27/2007 The bill payment dates should all be automatically calculated under the “Date” column. Rules for the date Rule1. e.g. 1 Month—the date should be 1 month after the date entered (as shown by the simple example 1/27/2007 one month is 2/27/2007 in the sheet) Rule2 if the date entered is the last day of the month, the calculated date should also be the last day of the month provided it is a working day. E.g 1/31/2007 one month is 2/28/2007. (provided 2/28 is working day) 2/28/2007 one month is 4/30/2007 (provided 4/30 is working day) Rule3 If the calculated date based on rule1 and rule2 is a non-working day, the date is pushed back by 1 till it becomes a working day. e.g 1/27/2007 two month is 3/27/2007 if 3/27/2007 is Saturday it becomes 3/28/2007 which is a Sunday, another non-working day. So the output should be 3/29/2007 Rule4, under rule3, the date cannot be pushed to the next month. Instead, we push the date forward. In the previous example assume 3/29, 3/30 and 3/31 are all public holidays, by rule3, it will be finally pushed to 4/1. But this becomes another month. So we push forward instead to 3/26 which is Friday. The output is 3/26/2007 Definition of working dates (Monday to Friday excluding the holidays listed in the sheet).........
View Replies!
View Related
Dollar Amount
How can I display the $xx.xx into a statement? I have these $ amounts in column A: 99.12 107.65 14500.99 Have the result in column B as: Please Pay Exactly$00000xx.yy (where xx is tenth, hundreds, thousands and yy is the cent) 00000 is to prevent forgery and to have the results in column C using same column A: Please Pay Exactly$0000xxDollars and yycents For example like Please Pay Exactly$000099Dollars and 12cents or Please Pay Exactly$000014500Dollars and 99cents
View Replies!
View Related
|
TRACKER
