• Conditional Formula for Week Mont year

    From Brian73@21:1/5 to All on Sun Sep 16 22:45:40 2018
    Hi, treading some new ground in Excel, and trying to make a formula to
    either multiply or divide by 4 to complete a budgeting sheet for
    expenditure uncured either weekly, monthly or annually, based on the
    value inserted and the data valuation cell!

    Any help is much appreciated!


    +-------------------------------------------------------------------+ |Filename: Capture.JPG | |Download: http://www.excelbanter.com/attachment.php?attachmentid=1059| +-------------------------------------------------------------------+



    --
    Brian73

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Vikram S Mathur FCA@21:1/5 to All on Sun Jul 14 14:34:30 2019
    On Monday, 17 September 2018 03:19:12 UTC+5:30, Brian73 wrote:
    Hi, treading some new ground in Excel, and trying to make a formula to
    either multiply or divide by 4 to complete a budgeting sheet for
    expenditure uncured either weekly, monthly or annually, based on the
    value inserted and the data valuation cell!

    Any help is much appreciated!


    +-------------------------------------------------------------------+ |Filename: Capture.JPG | |Download: http://www.excelbanter.com/attachment.php?attachmentid=1059| +-------------------------------------------------------------------+



    --
    Brian73

    Can you send me a worksheet with some sample data and what you require to be done so I can try and find a solution to the problem? Thanks.
    CA Vikram S. Mathur

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)