LinkBack URL
About LinkBacks
Hi all,
Can you please take a look at the attached file and tell me how to fix the errors in B31 and B32 in worksheets Text in Upper Case and Text in Upper Case (2).
Thank you,
Gos-C
Hi all,
Can you please take a look at the attached file and tell me how to fix the errors in B31 and B32 in worksheets Text in Upper Case and Text in Upper Case (2).
Thank you,
Gos-C
Using Excel 2010 & Windows 10
"It is better to be prepared for an opportunity and not have one than to have an opportunity and not be prepared."
B31 is referring to blank cell B30 and trying to interpret as a date.
If you bring up the formula auditing toolbar, you can watch the formula evaluate step by step.
Hi Shg,
Thanks for your help.
I modified the formulas in B31 and B32 as follows:
B31
B32
Please Login or Register to view this content.
Error is gone!Please Login or Register to view this content.
Gos-C
Seems very complicated. What's the purpose?
It is for a spreadsheet used to log daily report totals.
Gos-C
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks