I am using the formula =IFERROR((D10*0.5)+(E10*0.5),"") but in some field it gives me a percentage that rounds and others is giveing me a 4 digit percentage and I can't figure out why. Please assist.
See attachment.
I am using the formula =IFERROR((D10*0.5)+(E10*0.5),"") but in some field it gives me a percentage that rounds and others is giveing me a 4 digit percentage and I can't figure out why. Please assist.
See attachment.
You need to change all entries in column E to %.
Let say E35 is integer.
If you arehappy with the results, please add to the contributor's
reputation by clicking the reputation icon (star icon).
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
To undo, select Thread Tools-> Mark thread as Unsolved.
http://www.excelaris.co.uk
Thanks, I have checked and they are all a %
It must be something else.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks