if a2=a1

Jan Kalop

Jan Kalop

Active Member
Joined
Aug 3, 2012
Messages
389
what formula would look like to perform something like that

if b1=a1 then in c1 print nothing
 
Last edited:
Sort by date Sort by votes

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN
You must log in or register to reply here.

Similar threads

PuntingJawa
  • Solved
Nested formula with multiple criteria
Replies
7
Views
87
PuntingJawa
PuntingJawa
S
  • Question
Bold text using formula
Replies
1
Views
111
Fluff
Fluff
S
  • Question
Print to last column & row that has data
Replies
1
Views
172
ShawnSPS
S
Trevor3007
  • Question
if both a1 & b1 are not blank, then insert a '1' into cell c1
Replies
6
Views
141
Fluff
Fluff
S
  • Solved
VBL loop help
Replies
3
Views
101
mse330
M

Forum statistics

Threads
1,214,639
Messages
6,120,679
Members
448,977
Latest member
dbonilla0331

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