If funct quiz

heze
ββ
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)
School of Sheets (Smartsheet Partner)
If my answer helped please accept and react w/π‘Insightful, β¬οΈ Vote Up, β€οΈAwesome!
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!