help formatting
 

hi please can anyone help i am setting up a pricebook and im struggling with
the idea that i want to change a result after it is calculated ie after a
calculation say
£3.34 i need it to automatically alter the result to £3.99 any questions
please ask i am very new to excel so if its a easy function for give me

many thanks

help formatting
 

=ROUNDUP(YourFormula,0)-0.01

--
Kind regards,

Niek Otten

"mark kennedy" <mark wrote in message
...
hi please can anyone help i am setting up a pricebook and im struggling
with
the idea that i want to change a result after it is calculated ie after a
calculation say
£3.34 i need it to automatically alter the result to £3.99 any questions
please ask i am very new to excel so if its a easy function for give me

many thanks

help formatting
 

Hi thanks for your help worked a treat !

"Niek Otten" wrote:

=ROUNDUP(YourFormula,0)-0.01

--
Kind regards,

Niek Otten

"mark kennedy" <mark wrote in message
...
hi please can anyone help i am setting up a pricebook and im struggling
with
the idea that i want to change a result after it is calculated ie after a
calculation say
£3.34 i need it to automatically alter the result to £3.99 any questions
please ask i am very new to excel so if its a easy function for give me

many thanks