Formula Development Help

  • Thread starter Thread starter John C. Harris
  • Start date Start date
J

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
 
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
 
Back
Top