percentages

Hi can anyone help with these 2 issues.

1. trying to get a fourmulae to do the following in one cell


So in other words it works out the percentage formulae 1st if it sense its below 100% it then adds 2 to total passed then re-runs the total passed divided by total issued to show 100%

2nd issues

in percentage scale if it reads 9.5 excell will round it ip to 10 etc is there a formulae that will do the same for numbers under .5 example 9.2 = 9 but want it to show 10 because you can not close down 9.2 of a job but you can close down 10

issue 1 =IF(I3/F3<1,(I3+M3)/F3)IF(M3="",I3-L3(/F3) i can get the green part to work but not red part help

So if you want the cell to show 100% regardless of the real value, why not just type 100% in the cell? Sorry, but I don't understand what you are trying to achieve - your explanation is unclear.

Try =IF(B2/A2<1,(B2+C2)/A2,IF(D2="",B2-C2/A2)) where A2=805, B2=803, C2=2. I'm not quite sure what you are trying to achieve with IF(M3="".... in your original.

Paul

Thanks I have sorted it