search

seaswalker / posts

0 stars 0 forks source link

Excel If计算百分比 #17

Open seaswalker opened 3 years ago

seaswalker commented 3 years ago 
=VALUE(IF(A2=1,"1",A2/B2))

这样计算的结果是小数点浮点数，再修改单元格格式: image 这里还有一个IF判断, 如果A2的值是1，那么就是100%.