MULTIPLE CALCULATION

[Hardik Shah]

Hi,

I need formula for below mentioned query:

I am having very big calculation in Sheet-1. If i will give input in A1 & B1
of Sheet-1 i will get answer in C1 from very big calculation.

Now, i am having Sheet-2 which is having various combination of input
required in A1 & B1 of sheet-1.

What i need is, i wanted to put formula in sheet-2 as per below:

Put value of Sheet-2 A1 & B1 in A1 & B1 of sheet-1 and write answer in C1 of
Sheet-2 from C1 of sheet-1.

if you need to understand problem further please provide your mail ID so
that i can explain to you more.

Regards,

Hardik

 

[Niek Otten]

HI Hardik,

Look at the Data>Table command

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hi,
|
| I need formula for below mentioned query:
|
| I am having very big calculation in Sheet-1. If i will give input in A1 & B1
| of Sheet-1 i will get answer in C1 from very big calculation.
|
| Now, i am having Sheet-2 which is having various combination of input
| required in A1 & B1 of sheet-1.
|
| What i need is, i wanted to put formula in sheet-2 as per below:
|
| Put value of Sheet-2 A1 & B1 in A1 & B1 of sheet-1 and write answer in C1 of
| Sheet-2 from C1 of sheet-1.
|
| if you need to understand problem further please provide your mail ID so
| that i can explain to you more.
|
| Regards,
|
| Hardik

 

[Hardik Shah]

Dear Niek,

Thank you for your reply. But still i am not getting what i required. I have
sent you mail with the excel sheet on mail ID : (e-mail address removed)

Please check and revert back.

 

[Madiya]

Dear Niek,

Thank you for your reply. But still i am not getting what i required. I have
sent you mail with the excel sheet on mail ID : (e-mail address removed)

Please check and revert back.








- Show quoted text -

Hi Hardik,
Word of caution.
Don't send file attachments to anybody without their prior consent.
AND do not post anybody's mail id directly in NG. It will flood their
mail box with thousands of spam mails.

Regards,
Madiya