Entering Formula

HESH

Board Regular
Joined
Mar 3, 2011
Messages
52
Hello
Which is better and why ?
when entering formula to use Function dialog box , or entering the formula directly in cells
 

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

Richard Schollar

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
I guess it depends on whether you know what all the function arguments are and what data each is expecting.
 

JamesW

Well-known Member
Joined
Oct 30, 2009
Messages
1,197
Hi,

They are both the same. The Function dialog box can help you understand what the formula does, and what the different variables are.
 

HESH

Board Regular
Joined
Mar 3, 2011
Messages
52
Thank you both
but in the case of mid-level, whichever you prefer?
i think that Professionals do not use Function dialog , because it is not good fr nested formula , is this true !
 

Richard Schollar

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707

ADVERTISEMENT

I wouldn't use it (for most formulas) because it's a waste of my time as I know what the sequence of arguments is and what data I want to put in each).
 

T. Valko

Well-known Member
Joined
May 9, 2009
Messages
16,623
If you use Excel 2002 or later and have function tooltips enabled this is pretty much the same thing in a more compact display.

This comes in handy when you're several levels deep in a complex formula by letting you know which function you're providing the arguments to.

On a related note, Excel 2007 and later has a formula auto complete feature that lets you select the functions from a drop down list. Personally, I hate this and disabled it but you may find it helpful.
 

Forum statistics

Threads
1,141,019
Messages
5,703,763
Members
421,315
Latest member
awaisnazir139

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