If funct quiz
Options
Am trying to solve this query without succeeding please help .if value in cell B is greater than cell A values , divide by 2 and return answer in cell C. if Cell A value is greater than cell B value return A value in C. is the above query manageable.
Answers
-
Difficult to tell exactly what you want to do without some more detail, but taking an educated guess...
=IF(B@row>A@row, C@row/2, C@row)
👨🏼💻 Dan Palenchar | School of Sheets Solutions Consulting | Smartsheet Aligned Gold Partner
If this helped, help me & the SSC by accepting and reacting w/ 💡insightful, ⬆️ Vote Up, and/or ❤️Awesome!
- 🆘 Smartsheet Consulting Inquiries: schoolofsheets.com/workwithus
- ▶️ Smartsheet Tutorial Videos: schoolofsheets.com/youtube
PS - If you have a follow up response tag me @SoS | Dan Palenchar so I get notified of your reply!
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!