Formula Development Help

[John C. Harris]

I hope I explain this well:

I have a spreadsheet set to calcualte 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 formule 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 formula 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 excpet 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

 

[keyt]

You might try:

= if(E26>0, E26/E26, (if E26=0, "no entry",0))

 

[Biff]

Hi John,

Fro the first formula try this:

=IF(ISBLANK(E26),"",IF(E26>0,E26/E26,0))

For the second formula:

=IF(C10="1-SS",3,IF(C10=2,1,IF(C10=3,0.5,IF
(C10=4,0.25,2))))

Only enclose TEXT values in double quotes.

Biff