CODEWITHSUNDEEP
excel-formula
Kim Boothe
Kim Boothe

Reputation: 1

IF statement to display cell information

I am trying to write a formula for this spreadsheet, if cell a2 is greater than 0 then display the information from a new sheet and the cell f9

Upvotes: 0

Views: 41

Answers (1)

Bigyan Bhandari
Bigyan Bhandari

Reputation: 45

Welcome to SO, This may help you; 

=IF(A2>0,Sheet2!F9,"")

Or 

 =IF(A2>0,Sheet2!$F$9,"")

Sheet2 is the name of the next sheet from where you will pull information.

Thanks !

Upvotes: 1

Related Questions