Help With IF formula

L

Lukma

Board Regular
Joined
Feb 12, 2020
Messages
240
Office Version
  1. 2019
  2. 2016
Platform
  1. Windows
HI friend

Please i need a help with a formula i Use a LOOKUP Column N to Look up for Percentage
Now i Need In Column P a Formula with IF
IF N is Greater Than or Equal to 70% answer should Full and IF its less Than or Equal to 69% answer should be Half

Appreciate a help out

ILSP Offshore Vessel Tracking Time Spent-2022.xlsx
NOP
3126100%Prd-Island
3127100%Prd-Island
312860%Rigs&Barges
312910%Rigs&Barges
313015%Rigs&Barges
ILSP_Offshore_Vessel_Tracking
Cell Formulas
RangeFormula
N3126:N3130N3126=LOOKUP(2,1/($C$12:$C$600000=L3126)/($E$12:$E$600000=M3126),($F$12:$F$600000))
O3126:O3130O3126=IFERROR(VLOOKUP(M3126,Location,2,0),"")
 

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.
Sort by date Sort by votes
Kerryx said:
=IF(N3126>=70,"full","half")
Click to expand...
kerryx

Thanks for your respond but It seem its giving me an error answer

Please can you check with it

ILSP Offshore Vessel Tracking Time Spent-2022.xlsx
NOP
3126100%Prd-Islandhalf
3127100%Prd-Islandhalf
312860%Rigs&Bargeshalf
312910%Rigs&Bargeshalf
313015%Rigs&Bargeshalf
31310%Rigs&Bargesfull
31320%Rigs&Bargesfull
ILSP_Offshore_Vessel_Tracking
Cell Formulas
RangeFormula
N3126:N3132N3126=LOOKUP(2,1/($C$12:$C$600000=L3126)/($E$12:$E$600000=M3126),($F$12:$F$600000))
O3126:O3132O3126=IFERROR(VLOOKUP(M3126,Location,2,0),"")
P3126:P3132P3126=IF(N3126>=70,"full","half")
 
Upvote 0
Lukma said:
kerryx

Thanks for your respond but It seem its giving me an error answer

Please can you check with it

ILSP Offshore Vessel Tracking Time Spent-2022.xlsx
NOP
3126100%Prd-Islandhalf
3127100%Prd-Islandhalf
312860%Rigs&Bargeshalf
312910%Rigs&Bargeshalf
313015%Rigs&Bargeshalf
31310%Rigs&Bargesfull
31320%Rigs&Bargesfull
ILSP_Offshore_Vessel_Tracking
Cell Formulas
RangeFormula
N3126:N3132N3126=LOOKUP(2,1/($C$12:$C$600000=L3126)/($E$12:$E$600000=M3126),($F$12:$F$600000))
O3126:O3132O3126=IFERROR(VLOOKUP(M3126,Location,2,0),"")
P3126:P3132P3126=IF(N3126>=70,"full","half")
Click to expand...
Zero is answer should be Half and not Full

Thanks
 
Upvote 0
Sorry just change the 70 to 70%

Book1
ABC
1100% full
2100% full
360% half
410% half
515% half
60% half
70% half
Sheet1
Cell Formulas
RangeFormula
B1:B7B1=IFERROR(VLOOKUP(M3126,Location,2,0),"")
C1:C7C1=IF(A1>=70%,"full","half")
A6:A7A6=LOOKUP(2,1/($C$12:$C$600000=L3131)/($E$12:$E$600000=M3131),($F$12:$F$600000))
 
Last edited:
Upvote 0
Solution
Kerryx said:
Sorry just change the 70 to 70%

Book1
ABC
1100% full
2100% full
360% half
410% half
515% half
60% half
70% half
Sheet1
Cell Formulas
RangeFormula
B1:B7B1=IFERROR(VLOOKUP(M3126,Location,2,0),"")
C1:C7C1=IF(A1>=70%,"full","half")
A6:A7A6=LOOKUP(2,1/($C$12:$C$600000=L3131)/($E$12:$E$600000=M3131),($F$12:$F$600000))
Click to expand...
thanks But i guess there is a Problem with It i did exactly but the Zero answer is still showing Full

is It because i use lookup in Column N or am i missing out something
ILSP Offshore Vessel Tracking Time Spent-2022.xlsx
NOP
3126100%Prd-IslandFull
3127100%Prd-IslandFull
312860%Rigs&BargesHalf
312910%Rigs&BargesHalf
313015%Rigs&BargesHalf
31310%Rigs&BargesFull
31320%Rigs&BargesFull
ILSP_Offshore_Vessel_Tracking
Cell Formulas
RangeFormula
N3126:N3132N3126=LOOKUP(2,1/($C$12:$C$600000=L3126)/($E$12:$E$600000=M3126),($F$12:$F$600000))
O3126:O3132O3126=IFERROR(VLOOKUP(M3126,Location,2,0),"")
P3126:P3132P3126=IF(N3126>=70%,"Full","Half")
 
Upvote 0
Good , could you advise what was the issue with the 0% value?
 
Upvote 0
Kerryx said:
Good , could you advise what was the issue with the 0% value?
Click to expand...
Thanks kerryx i simple took out the Percentage from the Zero 0% from VLOOKUP because i was so stress out thanks and i appreciate.

Excel Formula: 
=IFERROR(VLOOKUP([@Column1],Info_Setting!$J$3:$M$90000,4,0),[B]"0%"[/B])
 
Upvote 0
Kerryx said:
Good , could you advise what was the issue with the 0% value?
Click to expand...

Hi Kerryx

I also have a Question and i really don't no if you can help out with a formula i made a post but i dont think am able to get around with it or a solution from friend or if am unable to explain better with what i require

Can you please take a look at my post Need Help With a Formula reposting my Data
 
Upvote 0
You must log in or register to reply here.

Similar threads

L
  • Solved
IF with multiple condition
2
Replies
16
Views
512
Legacy 143009
L
L
  • Solved
Formula in the helper column. need duplicate to be count as One
Replies
7
Views
167
KRice
K
O
  • Question
XLookup HELP!!
Replies
2
Views
317
Alex Blakenburg
A
L
  • Solved
Help with Formula to find in a list
Replies
3
Views
127
Legacy 143009
L
L
  • Solved
Help with IF Formula for my Data.
Replies
5
Views
351
Lukma
L

Forum statistics

Threads
1,215,054
Messages
6,122,897
Members
449,097
Latest member
dbomb1414

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top