Results 1 to 3 of 3

Logical values help required

Threaded View

  1. #1
    Registered User
    Join Date
    04-01-2008
    Posts
    54

    Logical values help required

    Dear All,

    Please help me out with below query

    This spreadsheet has Data columns and Month Columns
    Data columns has conditional formatting
    Value to input is 1 data
    Help Required
    If I enter 1 in any of the data column then it should do the calculation for consecutive month as below
    Example If 1 enter 1 in Data 1 column then it should perform the action for Month 1 as =C2*b2*a2 and display the result 3%

    Once the calculation is done then all the other data columns should become 0 and the consecutive months should become 0
    The same Data column value and month column value has to be displayed in Total and output columns

    Total column is for Data and output column is for Month values

    Condition is I may enter 1 in any of the data column then all the data columns and month columns should become 0
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1