solve this EXCEL formula for me before i go CRAZY please

movingtables · 22 Sep 2013 at 20:07

i want to give the following people a bonus of 10% on top
of their wages if they earn over £3,000 a week.

can someone edit this formula please:

=IF(B1>3000,+10%,"add","no"

I've given up lol's.

ExRayTed · 22 Sep 2013 at 20:11

Wrong forum dude! Stick it in the software section.

Russinating · 22 Sep 2013 at 20:11

Want us to do your homework for you lols?

Wallace · 22 Sep 2013 at 20:14

=IF(B11>3000,B11*1.1,"failed to make bonus")

dirtychinchilla · 22 Sep 2013 at 20:17

As above.

+10% isn't a formula

weringo · 22 Sep 2013 at 20:17

Your attempt at the formula amused me

dirtychinchilla · 22 Sep 2013 at 20:19

Also, for an IF statement you only have 3 variables, so you're trying to add extra to it, which isn't possible.

Participant · 22 Sep 2013 at 20:20

Someone missed that class lol

movingtables · 22 Sep 2013 at 20:25

no thats doesnt work.

IF they earn over £3,000 i want them to get 10% on top and
add up what their total wage is after the bonus of 10%

Wallace · 22 Sep 2013 at 20:27

That's exactly what it should do?

Wallace · 22 Sep 2013 at 20:28

In case you don't understand, if you multiply something by 1.1 it is the equivalent of 110% of the original value. So 10 % on top of their original wage...

dirtychinchilla · 22 Sep 2013 at 20:28

Indeed. Did you try just copying that formula in?

Wallace said:
In case you don't understand, if you multiply something by 1.1 it is the equivalent of 110% of the original value. So 10 % on top of their original wage...

I'll try and restrain my amusement

movingtables · 22 Sep 2013 at 20:31

ok it worked im just trying to look at the formula for future refference.
so i can remember.

thanks for the help.

movingtables · 22 Sep 2013 at 20:33

Wallace said:
In case you don't understand, if you multiply something by 1.1 it is the equivalent of 110% of the original value. So 10 % on top of their original wage...

what would the formula look like for 7%?

Wallace · 22 Sep 2013 at 20:33

Use the fx button next to the formula bar at the top, that gives you a little wizard which will help you with using new functions. As a breakdown of the IF statement it works as follows:

=IF(logic test, value if true, value if false)

So it tests a logical function and then returns a value of your choice depending on whether the function is true or not.

Wallace · 22 Sep 2013 at 20:33

movingtables said:
what would the formula look like for 7%?

B11*1.07 instead of B11*1.1

dirtychinchilla · 22 Sep 2013 at 20:36

I'm sorry to have to ask you, but do you know any maths?

movingtables · 22 Sep 2013 at 20:36

Wallace said:
B11*1.07 instead of B11*1.1

so 23% would look like this:

B11*1.23

?

dirtychinchilla · 22 Sep 2013 at 20:37

movingtables · 22 Sep 2013 at 20:38

dirtychinchilla said:
I'm sorry to have to ask you, but do you know any maths?

it's my weakest subject and i cant think that way due to medication.

basically my memory is fried.