Dear Experts,
Please find here sample workbook where i am trying to put ifs formula from cell Q5 to S7 but after close and reopen the formula get convert automatically with .xlfn.ifs, which is throwing "#Name?" error.
Request to you please do help me out on this error.
Many thanks and kind regards,
Neilesh
=iferror(your formula,"")
To attach worksheet Go advanced -> Manage attachments -> Choose file -> Upload
Don't forget to Mention your desired result in the sheet..
There should be sample data only, a lot of data creates confusion.
Thanks & Regards
Shivya
http://excelvbatipsforbeginners.blogspot.in/
Hi Shivya, thank you for your precious phase but the same i have already tried then also its throwing the error and getting automatically convert while reopening the workbook.
#NULL! 1 Incorrect Range Operators.
#DIV/0! 2 Divided By Zero.
#VALUE! 3 Incorrent Data Types.
#REF! 4 Invalid Range.
#NAME? 5 Formula or Range Misspelled.
#NUM! 6 Huge Value.
#N/A 7 Data is Missing.
#Name error refer to misspelled that means you have typed wrong word for function.
Does your excel compatible for ifs function ?
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Yes it is, i am using 2016 professional version 62 bit
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
Thank you popipipo for your valuable suggestion. Is there alternate solution for the ifs formula which can be matched with my present requirement. If you can please do provide alternate solution for Ifs formula from Cell Q5 till S7, would be a great help.
Many thanks and kind regards,
Neilesh
Maybe something like this:
=SUMPRODUCT((I3:O3=K3)*(I4:O4)-(I3:O3=I3)*(I4:O4))
Hi popipipo, the provided formula is not providing the correct result based on the drop down changes. Request to you please do provide the Ifs alternate from Cell Q5 till R7.
To help those trying to help you, please attach your latest version of the workbook where you say it isn't working.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Dear Expert,
It is already been uploaded in my post while starting the thread and cell also specified based on the dropdowns it is throwing error. Request to you please do help me out.
Modify the formula in Q4 as following & see if it works:
=IF('C:\Users\NDubey\Desktop\[BatchMaster Financial Planner_FY2018_Ver.09.xlsb]P&L Variance'!$CE$8=1,K4-I4,IF('C:\Users\NDubey\Desktop\[BatchMaster Financial Planner_FY2018_Ver.09.xlsb]P&L Variance'!$CE$8=2,O4-M4,IF('C:\Users\NDubey\Desktop\[BatchMaster Financial Planner_FY2018_Ver.09.xlsb]P&L Variance'!$CE$8=3,O4-I4,IF('C:\Users\NDubey\Desktop\[BatchMaster Financial Planner_FY2018_Ver.09.xlsb]P&L Variance'!$CE$8=4,K4-M4,IF('C:\Users\NDubey\Desktop\[BatchMaster Financial Planner_FY2018_Ver.09.xlsb]P&L Variance'!$CE$8=5,M4-I4,"")))))
Last edited by cbatrody; 11-20-2017 at 08:35 AM.
[QUOTE=cbatrody;4787779]Modify the formula in Q4 as following & see if it works:
Dear Expert,
I have tried with by paste as value the headings but the errors remains same. Request to you please do help me out.
What do you mean by "Paste as value the headings"?Originally Posted by Neilesh Kumar
Dear Expert, Sorry for the miscommunication. I have use the the same formula for Q4 and S7 which i have used for Q5 & S5 but the result is the same with #Name? error.
Please do help me out.
Perhaps a simple CHOOSE formula
=IFERROR(CHOOSE($Y$4,K5-I5,O5-M5,O5-I5,K5-M5,M5-I5),"")
Don
Please remember to mark your thread 'Solved' when appropriate.
btw.
IFS() function is available for Excel 365 (2016 for subscribers) and not available for Excel 2016 for Mac.
I don't think 62-bit version exist
Dear Experts,
Is there any alternate solution for Ifs formula error based on the drop downs from cell Q5 to R7, which supports Mac as well Windows both.
Your precious phase and valuable support would be appreciated.
Many thanks and kind regards,
Neilesh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks