what formular do i use to work out 10% of any number in the sheet?
the one i tryed was
=FLOOR(F2/10,100)
should it be
=FLOOR(F2*10,100)
or am i way off???
i have attached the sheet i need the 3 month average total devided by 10%
please help
what formular do i use to work out 10% of any number in the sheet?
the one i tryed was
=FLOOR(F2/10,100)
should it be
=FLOOR(F2*10,100)
or am i way off???
i have attached the sheet i need the 3 month average total devided by 10%
please help
to find 10 percent of a number, multiply that number by 0.10
in your case, =F2*0.10
Hi,
Try =F2/10 and simply format the result to the required number of decimal places.
Kind regards,
Robert
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks