[Solved] Making a formula

[davidsllc]

I need to make a formula:

=U9*0.07 and if greater than 30K add $500

[robleyd]

if greater than 30K

Assuming that refers to the result of U9*.07; you already have one part of the formula. To test the value of U9*.07 and add accordingly, the second part of the formula might be

Code: Select all

+IF(U9*.07 > 30000;500;0)

[RusselB]

Since the OP wants to add $500, then I would think an option could be

Code: Select all

=u9*.07+if(current()>30000;500;0)

[davidsllc]

I tried =U9*0.07+IF(CURRENT(U9)>30000;500;0) and it still did not work

[davidsllc]

So the formula I am trying to make is the total of U9 x 7% +$500 if over 30,000.00

[robleyd]

Both my suggestion and RusselB's behave as desired for me. What does 'did not work' mean - do you get an error?

See attached spreadsheet which uses both formulae - scroll across to U9.

[Villeroy]

+500 if which value is greater than 30000?
a) U9 or b) U9*0.07?

a) =U9*0.07+IF(U9>30000;500;0)
b) =U9*0.07+IF(CURRENT()>30000;500;0)
CURRENT() returns the calculation result so far, U9*0.07 in this case.
Equivalent b) =U9*0.07+IF(U9*0.07>30000;500;0)

[davidsllc]

It gave me the following error: #NAME?

[davidsllc]

I figured it out, Thanks so much

[RusselB]

I tried =U9*0.07+IF(CURRENT(U9)>30000;500;0) and it still did not work

You have a U9 in the parameter location of the CURRENT function. While that is a parameter location, it must be BLANK
Compare the actual formula I posted with the one you tried.