Build me an excel formula to look at a cell and output the value based on the results of a formula

已完成 已发布的 3 年前 货到付款
已完成 货到付款

I’m trying to use a formula to look at a cell on the "Data" sheet and output a value based on the formula on the "Result" sheet. The formula I’m trying to use is one that would allow me to look to see if “Kbbs” is in the cell and if so, remove “Kbbs” text from the cell to leave a value and then divide the resulting value by 1024. If there is no “Kbbs” then look for “Mbbs” if found then remove the text and display the value.

Aim is to cleanse data by removing text and get values in the same scale

Example cell value: 854Kpps or 1.2Mpps

Formula attempted: =IFS(SEARCH("Kpps",Data!F15),((SUBSTITUTE(Data!F15,"Kpps","")))/1024, SEARCH("Mpps",Data!F15),((SUBSTITUTE(Data!F15,"Mpps",""))))

Any help would be appreciated – I can only seem to get the “Kpps” side to work and not “Mpps” just get “#VALUE!” error

Ive tried OR and IF functions to

Thanks in advance

Craig

Excel

项目ID: #26335272

关于项目

7个方案 远程项目 活跃的3 年前

授予:

Jayant222

Hi there, I am an expert in this . I have gone through the project description and can help you on this project. Thanks, Jayant

£15 GBP 在2天内
(5条评论)
2.1

有7名威客正在参与此工作的竞标,均价£17/小时

khushh07

Hello Greetings to you!! I am an excel(Macro)/Visual Basic expert and interested to work with your project. I have checked your requirements and that makes complete sense to me. I assure you of a high-quality job. Plea 更多

£20GBP 在1天里
(289条评论)
7.1
manishsharma708

Hi, I have good experience of Data processing, Data entry & Excel. Currently i working with respective company. same work also there. Please give me your project.

£12 GBP 在6天内
(0条评论)
0.0