Numbers
How to add 20%? I have, say, 2345 in cell D2 and I want that figure + 20% of 2345 in E2
Help please.
MacBook Air 13″, macOS 11.2
You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
How to add 20%? I have, say, 2345 in cell D2 and I want that figure + 20% of 2345 in E2
Help please.
MacBook Air 13″, macOS 11.2
In E2: =D2+D2*0.2
OR: =D2*1.2
(Numbers will immediately change the multiplication operator ( * ) to a multiplication sign (see below), but will NOT recognize or set the multiplication sign if it is entered sidectly into the formula editor.)
Regards,
Barry
In E2: =D2+D2*0.2
OR: =D2*1.2
(Numbers will immediately change the multiplication operator ( * ) to a multiplication sign (see below), but will NOT recognize or set the multiplication sign if it is entered sidectly into the formula editor.)
Regards,
Barry
Numbers