Office 2000 SR-1 Excel - performing no calc if adjacent cell is xxxx

[SolarMax]

I am not even sure how to ask this question...

I am performing a series population calculations based on the type o
terrain represented, in this case land or ocean.

This process assumes the globe is divided in to as few as 1 or as man
as 30 sectors. Each of these sectors are either Land or Ocean.

I have a working calculation that determines the total number of eac
based on the size of the globe and the segmentation of that globe b
euqlly sized sectors, which can range up to 30.

In my current example, it has only 27. Sixteen are ocean and 11 ar
land.

Below these working calculations I would like to list 30 rows in colum
B that would place the word LAND in the first 11 cells and then plac
the word OCEAN in the next 16, finally leaving the last 3 blank.

Next to Column B is Column C where a populatioin calculation is to b
performed if the cell on the same row in column B has the text LAND. I
the word OCEAN is present or it is blank (last three) then it shoul
return the result N/A

The population calculation is simple, divide the total population b
the number of land sectors (in this case 11) and place the result i
each cell in Column C next to the cell in Column B that reads the tex
LAND.

I hope I have provided you with the information for you to aid me.

Regards,
SolarMa

 

[Frank Kabel]

Hi
try the following for column C
=IF(B1="LAND",your_population_calculation,NA())

HTH
Frank