Across the Top I have a Percentage for an Item in a Store, Along the side I have the same data just vertical. All I want is to create a calculated field to populate the middle but I can't get it to work correctly.
Heres the formula I'm Trying to use:
=('percentage ' -'percentage 14' )/(SUM('percentage ','percentage 14')/2)
Here's a screen shot of the worksheet:
Capture 2.PNG
Help is appreciated. thank you
(How to) Upload a Workbook directly to the Forum
(please do not post pictures or links to worksheets)
- Click Advanced next to Quick Post button at the bottom right of the editor box.
- Scroll down until you see "Manage Attachments",
- Click the "Choose" button at the upper left (upload from your computer).
- Select your file, click "open", click "upload"
- Once the upload is completed the file name will appear below the input boxes in this window.
- Close the Attachment Manager window.
- Click "Submit Reply"
Note: Please do not attach password protected workbooks/worksheets
Ensure to disable any Workbook Open/Autorun macros before attaching!
Ben Van Johnson
Hi -
You would need to upload a sample spreadsheet, with any sensitive data removed, and a couple of examples of what the correct outcomes should be. I can't really tell from the screen shot what cells you are referencing or what the formula is supposed to be determining.
____________________________________________
If this has solved your problem, please edit the thread title to add the word [SOLVED] at the beginning. You can do this by
-Go to the top of the first post
-Select Thread Tools
-Select Mark thread as Solved
If I have been particularly helpful, please "bump" my reputation by pressing the small star in the lower left corner of my post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks