Sorry, then I will change my question, please check my updated screenshot and file attached https://prnt.sc/M2-kcsimj4KR.
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
Last edited by maniacs205; 06-13-2022 at 05:21 AM.
Which version of Excel is this for? Or does it need to work with Google Sheets?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
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
hi
its for google sheet
Thread moved to the correct sub-forum.
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
Don't provide links to screenshots - a workbook attached to your post is better, but you can attach a screenshot directly here, too. Nobody should have to follow links.
Sure no worries, I made in excel sheet now :
https://docs.google.com/spreadsheets...iJM/edit#gid=0
Last edited by AliGW; 06-13-2022 at 05:37 AM. Reason: PLEASE don't quote unnecessarily!
Try
=IF(ISTEXT(B2),LOOKUP(B2,{"High","Low","Medium"},{9.9,3.33,6.67})/D2,B2/D2)
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Thank you, worked now !
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks