CAn anyone tell me how to do formulaes for excel please!

[NeedCoffee]

I need a formulae that is if the cell amount is lower than 0 it needs multiplying by 5%.
TIA

=IF(A1

Oh, if the number is greater than 0, BTW, it will return the message 'False'.

Thank you, how do i get it to return a 0 instead of false?

=IF(A2

Thank you so much, I've been trying to do that since last night!

Sorry, another question-Any idea how to make it come back as a positve ammount rather than a negative?

um and to no decimal places-rounded up? Or is it really arkward?

=IF(A2

Oh shoot, it went bold!!

=if(a1

It is cell formating - you right click and change the no of decimal places

I wasn't sure about the rounding part, Katy! If you go to no decimal places, does that automatically round it? Yes, it must, duh!!

Yep

Thank you thank you thank you Am stupidly chuffed that I've nearly got a spread sheet that I nearly did all by myself!