J
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
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