If cell is greater than help

hkkitcat

New Member
Joined
Aug 4, 2021
Messages
6
Office Version
  1. 365
Platform
  1. Windows
What am I doing wrong? I want column C to show "No" if the value in column B is greater than 20 (highlighted cells).
This board has been so helpful for an Excel beginner like me, thank you!

excel help.xlsx
ABC
1Requested AmountActivityInclude?
2#VALUE!#VALUE!
141 via-11.0 mCi/via11.0Yes
151 via-11.0 mCi/via11.0Yes
161 via-11.0 mCi/via11.0Yes
171 via-11.0 mCi/via11.0Yes
181 via-12.0 mCi/via12.0Yes
191 via-12.0 mCi/via12.0Yes
201 via-187.0 mCi/via187.0Yes
211 via-10.8 mCi/via10.8Yes
221 via-16.0 mCi/via16.0Yes
231 via-12.0 mCi/via12.0Yes
241 via-12.0 mCi/via12.0Yes
251 via-12.0 mCi/via12.0Yes
261 via-100.1 mCi/via100.1Yes
271 via-12.0 mCi/via12.0Yes
281 via-12.48 mCi/via12.48Yes
Sheet3
Cell Formulas
RangeFormula
B2,B14:B28B2=(RIGHT(LEFT(A2,LEN(A2)-7),LEN(LEFT(A2,LEN(A2)-7))-6))
C2,C14:C28C2=IF(B2>"20","No","Yes")
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.
I'd suggest changing column B values to numbers
eg
Excel Formula:
=(RIGHT(LEFT(A14,LEN(A14)-7),LEN(LEFT(A14,LEN(A14)-7))-6))+0

Then remove the quote marks from 20
Excel Formula:
=IF(B14>20,"No","Yes")
 
Upvote 0
Solution
Looks like you could also consider this simpler formula for column B
Excel Formula:
=-MID(LEFT(A14,FIND(" ",A14,3)),6,9)
 
Upvote 0
You're welcome. Thanks for the follow-up. :)
 
Upvote 0

Forum statistics

Threads
1,213,526
Messages
6,114,136
Members
448,551
Latest member
Sienna de Souza

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