Help required for Excel Formula

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

him1803

Thread Starter
Joined
Nov 30, 2011
Messages
1
Hello all,

I just stuck up in one problem, and I need your expert help in solving it.

The problem is -

I have created an excell sheet with monthly consumption data date wise summing up all at bottom of table.
A second worksheet is created (for costing calculation with today & todate figures) taking reference from the first one.
Now, I need that whenever I put in one master cell as 1, 2, 3, 4...(representing dates in first workbook), the values of today & todate columns are filled with the values (entered in first workbook).

Also, if you can tell me -

How to put this condition in one single cell -

=IF(I3=1,CONCATENATE('Backup Data'!E11))&(IF(I3=2,CONCATENATE('Backup Data'!E12)))

I am getting the result as - if first condition true, its value is displayed followed by FALSE of the second formula and reverse is for 1st condition false & second is true, the result is FALSE210.

Thanks

Himanshu
 

Keebellah

Hans
Trusted Advisor
Joined
Mar 27, 2008
Messages
6,642
Hi Himanshu, welcome to the board,

I cannot picture the problem reading your post, do you have a small non-private data sample to show what you have and what you want?

Furthermore, concate creates string values so I do not think you need this.
Post a samplke so we can see what you need / want.

Also, you forgot to mention the version of Excel you're using
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Members online

Top