need help with IF in excel 2016

...OR here's a formula that works. NOD to Ford for the more efficient Find method. I put his formula in an INDIRECT function to generate a Defined Name instead of text, then used the returned value as a divisor. Zeros cause an error, which yields "" through the IFERROR clause.

=IFERROR(1/(1/INDIRECT(LEFT(NAME,FIND(" ",NAME)-1)&"_Gas_Saturday_Initial")),"")

Please click the Add Reputation star below any helpful posts, and if you have your answer, mark your thread as SOLVED (Thread Tools up top). Thanks!-Lee

the last formula didn't work so here is a link to my Excel file so that you can see what I'm working with

https://www.dropbox.com/s/vhhghgoae6...heet.xlsm?dl=0

the file does have macros so if you see a warning it's just a macro to create a folder with the next Saturday's date then save as pdf

Originally Posted by leelnich

Perhaps it didn't work because you hadn't defined the name Jean_Gas_Saturday_Initial! When I did that and applied the formula with Name = "Jean Doe", it worked fine.

ps. Ford, I think the formula goes in SAT!$H$29

Please click the Add Reputation star below any helpful posts, and if you have your answer, mark your thread as SOLVED (Thread Tools up top). Thanks!-Lee

well those names where generic names and the defined names was for the real names... srry forgot to change the defined names.. b10 for each name tab goes in h29 Saturday depending on the name selected