Prompt Title: Troubleshooting Data Validation on Cells with Formulas in Excel

Created 1 year ago
Votes 0
Views 475 times
0

Prompt Detail:

I've been trying to use data validation on cells that have formulas in them But it seems like it doesn't work even on the latest excel versions? For example, cell A2 contains formula =B2+C2 If i set the validation on cell A2 saying that the sum shouldn't be greater than 10, any number could still be put into cells B2 and C2,
avatar
Chat Prompt
Shared 1346 prompts
Created 1 year ago
  • youu aree really a excellent webmaster. The web site loasding pace iis amazing. It sort off eels thatt you're ding anny uunique trick. In addition, The contenys aare masterpiece. you've perforrmed a excellent activity iin tuis topic! - sitemap.xml - 10 months ago

Leave a Comment

Related Tag Prompts

336
0
Excel Expert
1 year ago 2023-01-22 21:26:36 AIPRM