•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Looking to automatically put data into a cell dependent on the values of specific other cells in that row
Hello, the goal is to automatically present the value in the “split amount” columns cell to be half the value of the “total amount” columns cell.
Additionally, a value in “split amount” cell should only appear if the value in the “SPLIT?” Columns cell is “yes” otherwise, it should be blank or 0.
Is this possible? I don’t know if it is but I think it’d be cool to have it be automatic. Imgur pic attached
https://imgur.com/a/hyZJxq8
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com
#Excel alternatives for data analysis
#Excel compatibility
#Excel alternatives
#big data management in spreadsheets
#generative AI for data analysis
#conversational data analysis
#row zero
#real-time data collaboration
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions
#split amount
#total amount
#SPLIT?
#cell
#value