using two formulas

rainmantwo

New Member
Joined
Jun 13, 2002
Messages
45
How do form a statement to use two formulas in one cell. I want to add 5% then round down the number.

=E9*(1+2%)


=ROUNDDOWN(H9,0)

tHANKS bRIAN
 

Some videos you may like

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

awalle

Board Regular
Joined
Jul 12, 2006
Messages
56
if I understood, you need to mix the two formulas as follow:

=ROUNDDOWN(E9*(1+2%),0)
 

Scott Huish

MrExcel MVP
Joined
Mar 17, 2004
Messages
19,958
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
That formula won't increase the amount 5%, it increases it 2%, but perhaps:

=INT(E9*1.05)
 

Watch MrExcel Video

Forum statistics

Threads
1,114,059
Messages
5,545,759
Members
410,704
Latest member
Cobber2008
Top