LinkBack URL
About LinkBacks
You can't divide B3 by D3 because B3 has text in it.
You can't divide B3 by D3 because B3 has text in it.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Sorry, then I will change my question, please check my updated screenshot and file attached https://prnt.sc/M2-kcsimj4KR.Originally Posted by TMS
I want to know the formula, at colomn E2, how to divide B by D and drag down to E5 ?
in a condition, changing the text value to becomes number as following :
low -> 3.33
medium -> 6.67
high -> 9,90
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks