Google Sheets: Cell should report 'yes' if the sign '<' appears in one of two cells

B

booms

Board Regular
Joined
Dec 2, 2010
Messages
60
Hi
This would be easy in Excel but can't seem to make it work in Google Sheets. Should be some combination of IF, OR and SEARCH but I'm stuck!
I'd like cell C3 to display 'Yes' if either of cells A3 or B3 have the character '<' in them.
I wondered if the Google SEARCH function doesn't work well for this character?

Also any tips in general for working with brackets and IF statements in Google Sheets? Excel would set out nicely where the 'value if true' and 'value if false' where as I typed, but it doesn't seem so clear in Google Sheets.

Thanks!
 

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.
Sort by date Sort by votes
Try:
Excel Formula: 
=IF(OR(ISNUMBER(SEARCH("<",A3)),ISNUMBER(SEARCH("<",B3))),"Yes","No")

Edit: Sheets does the same after you enter the comma. It highlights the field you're inputting in, but goes away once you start entering stuff.
 
Last edited:
Upvote 0
Cubist said:
Try:
Excel Formula: 
=IF(OR(ISNUMBER(SEARCH("<",A3)),ISNUMBER(SEARCH("<",B3))),"Yes","No")

Edit: Sheets does the same after you enter the comma. It highlights the field you're inputting in, but goes away once you start entering stuff.
Click to expand...
That worked perfectly! Thankyou very much
 
Upvote 0
You must log in or register to reply here.

Similar threads

W
  • Solved
Create two Buttons that works in mobile in Google Sheets
Replies
1
Views
201
Wojciech
W
J
  • Question
Formula that works in excel but not in Google Sheets
Replies
0
Views
284
jeremypyle
J
M
  • Question
Need help with logarithmic function
Replies
0
Views
240
Margooox
M
T
  • Question
Golf Simulator League - Calculating Golf Handicaps for Google Sheets
2
Replies
12
Views
2K
Fluff
Fluff
C
  • Solved
Count amount of numbers in a cell? Works in Excel not Google Sheets??
Replies
8
Views
511
c.clavin
C

Forum statistics

Threads
1,216,500
Messages
6,131,016
Members
449,615
Latest member
Nic0la

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