Formula Help

  • Thread starter Thread starter Dimitri
  • Start date Start date
D

Dimitri

Hello:

On a seperate spredsheet I have created a synopsis but am having to enter
the information manually. Was hoping to do the following through a formula:

If Column A = 1 and Column B = $100,000 - on the seperate sheet would like a
formula to pick up ther data

Column A Column B
1 $100,000

Dimitri
 
try this...

=if(sheet2!a1 = 1, b1,"")


this returns the value of b1 if there is a one otherwise it returns
"".
 
Back
Top