What I am needing is a formula to list the result of multiplying cell A1 by.75 in cell B1, and then divide cell B1(the result of A1) by 52, which the result will be in Cell C1. For example:
Cell A1 is $50,000, and it is the only cell that has information typed in on the sheet. I enter the formula I need. Now Cell B1 shows $37,500( or 50,000x .75), and Cell C1 shows 721.15( or 37,500 /52).
The formula I am asking for will fill B1 and C1 with the appropriate information.
Any help would be great.
Thanks,
CB
You have already solved your own problem. Just replace the succeeding dollar values by the cells from which they come. E.g. Cell A1 is $50,000,... Cell B1 shows $37,500( or 50,000x .75) ===> in B1:
etc=A1*0.75
---
Ben Van Johnson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks