I am trying to create a workbook in Excel 2007 that shows two different revenue recognition scenarios (i.e. if we booked revenue one way, or another). I am not sure how to go about setting up this worksheet in Excel. Would the What-If Analysis tool be useful here? If so, how do I go about setting this up to capture the information?
Hi,
It's probably sufficient to have two separate sheets to show the results for each of the two scenarios. However to help further we really need to understand your data and the two sets of scenario rules that you wish to apply.
Put together an example workbook showing your data and the results you expect to see for each scenario and some notes which explain how you have arrived at the results.
Regards,
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks