Hi Guys,
I am looking the formula which pick the text on if those text have value 2000 or more than that.
i am using the formula as shown below, but if any text in between have less than 2000 its showing blank. which i am not looking. PLease help me.
=IF('Summed Turnover-ALL'!I7>=2000,'Summed Turnover-ALL'!C7,"")
Data as shown below
Please Login or Register to view this content.
Bookmarks