ExcelBanter - Formula

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Formula (https://www.excelbanter.com/new-users-excel/4890-formula.html)

J.C.De

Formula

How do I formulate the following in Excel.

A1 A2 A3
45 55 {(45+55)}*30%
= 30

I hope I made myself clear. What I want is
formula in A3 which will directly give me 30%.
TIA

JE McGimpsey

One way:

= (A1 + A2) * 30%

In article ,
"J.C.De" wrote:

How do I formulate the following in Excel.

A1 A2 A3
45 55 {(45+55)}*30%
= 30

I hope I made myself clear. What I want is
formula in A3 which will directly give me 30%.
TIA

J.C.De

Thanx.

"JE McGimpsey" wrote in message
...
One way:

= (A1 + A2) * 30%

In article ,
"J.C.De" wrote:

How do I formulate the following in Excel.

A1 A2 A3
45 55 {(45+55)}*30%
= 30

I hope I made myself clear. What I want is
formula in A3 which will directly give me 30%.
TIA

All times are GMT +1. The time now is 03:15 AM.