LinkBack URL
About LinkBacks
I have this formula that I am trying to put an iferror on and it's not working. I did not make this formual one of the engineers did, so I'm not sure why my iferror is not working. Any suggestions.
Please Login or Register to view this content.
I have this formula that I am trying to put an iferror on and it's not working. I did not make this formual one of the engineers did, so I'm not sure why my iferror is not working. Any suggestions.
Please Login or Register to view this content.
Like this?
=IFERROR((1+0.31*BF170^2^5),"")
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
IFERROR only works in Excel2007 or later and would be written as:
=IFERROR((1+0.31*BF170^2)^0.5,"")
if you have another version try:
=IF(ISERROR((1+0.31*BF170^2)^0.5),"",(1+0.31*BF170^2)^0.5)
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Thank you so much. I have no idea what I did wrong, but it is working. Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks