Formula HELP

[John C. Harris, MPA]

I hope I explain this well:

I have a spreadsheet set to calculate Home Visit Reports for a Social
Service Agency

Column B is an entry field for a LEVEL
Colum D and E Have entry fields for number of visits.

Column F should look at Column E and determine the number. The current
formula is:
=IF(E26>0, E26/E26,0) which of course looks at E and if the number is
greater than 0 divides the number by itself and returns 100% as an answer,
if not it returns 0%. I also need the same formula to return a "No Entry" if
the field is Blank. I have tried adding : or IF(E26 is null, "No Entry") but
that doesn't work.

The next problem is Column G which if a string of IF statement that look at
the LEVEL in Column B and assigns a weight to the number. The current
formal is:
=IF(C10="1-SS","3", IF(C10="2","1", IF(C10="3","0.5",
IF(C10="4","0.25","2"))))

This appeared to be working at first, but it will not return the correct
answer for any LEVEL except for 1-SS. All others are returned as 2. I assume
it has something to do with the "" "" but when removed the formula does not
work at all?

Any ideas on this anyone??

TIA

 

[Dale Hymel]

The first part
=IF(E26>0,1,IF(E26="","No Entry",0))

The second part.

It returns a 2 because it is looking for a TEXT 2 ("2"). If C10 contains
numbers, they IF statements are looking for Text and since none is found, it
returns the final 2.
TRY
=IF(C10="1-SS",3, IF(C10=2,1, IF(C10=3,0.5, IF(C10=4,0.25,2))))