IF FORMULA INCASE BLANK & NON BLANK

AYSHANA

Board Regular
Joined
Oct 16, 2021
Messages
90
Office Version
  1. 2019
  2. 2013
Platform
  1. Windows
good day to all!
hope doing good!

i would like to ask a help with my formula.
if i have a (random text in the column) i want to return (the word "check" in the other column) and if the column is blank to return a blank.

kindly refer to the following example

Book1
FGHIJ
1
2
3ANTI-BCHECKshould return check
4ANTI-ACHECK
5CHECKshould return blank
6HICHECK
7BYECHECK
8DONECHECK
9CHECK
10CHECK
11CHECK
Sheet1
Cell Formulas
RangeFormula
G3:G11G3=IF($F$3:$F$30=$F3,"CHECK","")
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).
HI
Simply
Excel Formula:
=IF(F3<>"","CHECK","")
 
Upvote 0
Solution
You are very welcome
And thank you for the feedback
Be happy and safe
 
Upvote 1

Forum statistics

Threads
1,216,568
Messages
6,131,462
Members
449,652
Latest member
ylsteve

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