Multiply Column
I am having trouble with the final formula for this spreadsheet.
I want to be able to select "Holiday/Sunday" from the drop down men in column H, and have it multiply the total in column F by 2. There is already a formula in column F that sums column E-D.
How do I do this?
Pictures are pretty useless to work with. I can't see what your existing formulae are. In future, attach a workbook.
Try something like:
Formula:
Please Login or Register to view this content.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
it is difficult to discern what you want and where from screen shots, however, if you want it in the formula in col F you could write it as
=IF(H7="Sunday/holiday",(E7-D7)*2,E7-D7).
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Sorry for not posting an excel file (I instantly regretted it)
You guys are wizards! Thank you both so much!
:D
good, glad to have helped. And since you're new to the forum, you can thank any and all who helped you by clicking on "* add reputation" as that is how we advance on this forum.
BTW, the forum moderators like it if you mark your post as solved by using the thread tools dropdown at the top of this post (if you haven't already).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks