Results 1 to 6 of 6

Thread: How to apply more than one formula to single column?

  1. #1
    Join Date
    Nov 2009
    Posts
    580

    How to apply more than one formula to single column?

    Hi All,
    I have to do the complex excel transaction . For this excel transaction I need to apply more than one formula to single column. I have not yet tried this type of the excel transaction.
    If anyone know how to apply more than one formula to single column , then let me know that. Your any help over this will be appreciable.

  2. #2
    Join Date
    Apr 2008
    Posts
    4,642

    Re: How to apply more than one formula to single column?

    Hi friend,

    To apply the multiple formulas for a single column you need to use concept of the filters. To achieve the multiple formulas you need to apply multiple filters over single excel column.
    Suppose you want to calculate the square as well as the cube of the one value of the excel column, for this you need to apply one filter to calculate the square and another to calculate the cube of that value

  3. #3
    Join Date
    May 2008
    Posts
    4,570

    Re: How to apply more than one formula to single column?

    Hi ,

    I think you should go for macros of the excel. You will need to create the macro to use multiple formulaover single column. I don't know this macro which is used multiple formulas but My fried had achieved same excel transaction using macro concept. The advantage of using macro is that we can reuse the macros anytime with minimal time expense. I hope this may solve your multiple formula problem of the excel.

  4. #4
    Join Date
    Apr 2008
    Posts
    2,139

    Re: How to apply more than one formula to single column?

    Hello,

    I am giving you one example for how to use the multiple formula for single cell. Suppose I want to check if the value in the given cell is number or not. As well as I want to find the sum of the this cell value with another cell value then the formula to find out this value is as below:
    Sum=(SUM(IsNumber(K5:K15),(K5:K15))

  5. #5
    Join Date
    Jan 2008
    Posts
    3,755

    Re: How to apply more than one formula to single column?

    Hi,
    It's very complicated to use the multiple formulas over single excel cell. Normally for entering the single formula we hit only "Enter". But to enter the multiple formulas you need to press the key key combination of the "CONTROL+SHIFT+ENTER".
    Example:
    Formula=SUM(ISNUMBER(J6:J16))

  6. #6
    Join Date
    Nov 2009
    Posts
    580

    Re: How to apply more than one formula to single column?

    Hi All,

    I have tried to use the this key combination of the "CONTROL+SHIFT+ENTER". And it very easy for me to apply the multiple formulas. I have successfully applied the more than two formulas for single cell. Now I don't have any barrier to use multiple formulas in my excel transaction.
    Thanks lot for your entire help!!

Similar Threads

  1. Replies: 1
    Last Post: 09-02-2012, 09:19 AM
  2. Find The Value of one column in another column
    By Charth in forum Windows Software
    Replies: 3
    Last Post: 23-02-2011, 03:01 AM
  3. Replies: 3
    Last Post: 09-12-2009, 01:11 PM
  4. mysql update column with another column
    By Gunter in forum Software Development
    Replies: 3
    Last Post: 23-05-2009, 09:44 AM
  5. Getting the MAX value from a column
    By rupak in forum Software Development
    Replies: 4
    Last Post: 31-01-2009, 11:36 AM

Tags for this Thread

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
  •  
Page generated in 1,716,386,186.42608 seconds with 17 queries