Simple Formula Help!

asjmoron

Board Regular
Joined
Apr 26, 2016
Messages
92
Hey guys,

I have column with 500 repeated formulas.

The formula is

=IFERROR(IF('052'!E44="","",'052'!E44),"")

BUT....the E44 is different on each line with no sequential order. I need to remove the "IFERROR(" and ,"") from every line without effecting the IF formula criteria.

any help?!
 
Last edited:

Some videos you may like

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,201
Change the first instance to:

=IF('052'!E44="","",'052'!E44)


then double click on the Fill Handle.
 

asjmoron

Board Regular
Joined
Apr 26, 2016
Messages
92
Thanks for your reply.

however all this does is replaces the whole forumula but I need to retain the nested IF formula
 

gaz_chops

Well-known Member
Joined
Apr 29, 2003
Messages
6,468
Platform
  1. MacOS
Use find & replace,
replace =IFERROR(
with '

replace
,"")
with ""

replace '
with =
 
Last edited:

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,201

ADVERTISEMENT

Thanks for your reply.

however all this does is replaces the whole forumula but I need to retain the nested IF formula

You are asked to modify the first instance of the formula and drag down the modified formula by applying double click on the fil handle of the cell of the first instance.
 

Yongle

Well-known Member
Joined
Mar 11, 2015
Messages
6,977
Office Version
  1. 365
Platform
  1. Windows
@Aladin Akyurek - I do not think the OP wants the cell reference to change from what is in the original formula

=IFERROR(IF('052'!E44="","",'052'!E44),"")

BUT....the E44 is different on each line with no sequential order. I need to remove the "IFERROR(" and ,"") from every line without effecting the IF formula criteria.

OP has this situation
row 10 is =IFERROR(IF('052'!E44="","",'052'!E44),"")
row 11 is =IFERROR(IF('052'!E100="","",'052'!E100),"")

Your suggestion using fill Handle
row 10 =IF('052'!E44="","",'052'!E44)
row 11 =IF('052'!E45="","",'052'!E45)

OP wants
row 10 =IF('052'!E44="","",'052'!E44)
row 11 =IF('052'!E100="","",'052'!E100)


@asjmoron please confirm this is what you want
 
Last edited:

gaz_chops

Well-known Member
Joined
Apr 29, 2003
Messages
6,468
Platform
  1. MacOS

ADVERTISEMENT

@Yongle, that is how i read it, if it is then the solution i suggested should work.
 

asjmoron

Board Regular
Joined
Apr 26, 2016
Messages
92
@yongle yes thats exactly what a I need.

@gaz_chops I did try find and relace but as it removes part of the formula, it then errors and does not allow the changes to be made.
 

gaz_chops

Well-known Member
Joined
Apr 29, 2003
Messages
6,468
Platform
  1. MacOS
@yongle yes thats exactly what a I need.

@gaz_chops I did try find and relace but as it removes part of the formula, it then errors and does not allow the changes to be made.

If you do it in the steps as I suggested, then it will work. By removing the = sign it becomes text, then the last step is to add the = sign back.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,505
Messages
5,602,061
Members
414,498
Latest member
jordanmiller7890

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
Top