# Excel issue

Closed
sanober - Aug 15, 2010 at 05:47 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Aug 17, 2010 at 11:45 PM
Hello,

I have a problem that if i have excel sheet of 20 rows and 200 columns and i want to perform some function like comparing each entry with certain number (for eg :0.25) and if the entry is greater than 0.25 then function returns "yes" else it returns "". how can i do it using excel ?

Related:

## 3 responses

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Aug 16, 2010 at 05:56 AM
you need another set of empty cells 20x200. In this range of empty cells if you type the formula in the first left hand cell then you can just copy that down and to the fight I have given a small example sheet which you can download from this web page

http://www.speedyshare.com/files/23821960/sanober.xls

suppose data is in A1 to A10 and B1 to b10 that is 10x2

now see the formula in D1.
copy D1 down upto D10 and also E1 to E10.(using control+c and control+v)
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Aug 15, 2010 at 10:04 PM
quote
comparing each entry with certain number (for eg :0.25) and if the entry is greater than 0.25 then function returns "yes" else it returns "
unquote

in an empty cell type this formula(suppose parent cell is A1)

=if(a1>0.25,"yes","")
thanks venkat, it worked ! can i perform the same thing for the entire table of 20x200 dimension. i mean can i specify the range of entire table for performing comparison of values against 0.25 , because doing one by one for each entry will take much time