Are you getting the #NAME?Appears One way of avoiding this is to use the F3 function key instead of typing the name F3 will show a list of names in your workbook within a dialog box Use the F3 key as and when you need to type the named reference within your formula3y yes, that is the direct copy and paste 1 Share Report Save
How To Use The Ifs Function In Microsoft Excel Sage Intelligence