Help With Excel

[salim123]

 

 

 

this is a small pic of my program

 

 

 

used off someone eslse

 

 

 

dont mind the markings

 

 

 

 

 

 

 

is there a way to make a formula that if the text box has the words "torags plate" it adds a certain amount of money to the total cash box?

 

 

 

 

 

 

 

click the link in my sig if u want to download it

[Ragen]

Double post.

 

 

 

 

 

 

 

Edit - My Bad. They were two totally different threads.

[Darrel104]

Here is my solution, I used Google spreadsheets but they are mostly the same.

 

 

 

 

 

 

 

 

 

 

=if(conditonal test,value if true,value if false)

[salim123]

crazy

 

 

 

im gonna try this tonight ive been trying to do this for such a long time

 

 

 

 

 

 

 

but how do u do it so that its all in 1 form

 

 

 

so that works for 1

 

 

 

but how do u get if if a1 =(torag plate, 10) (torag legs, 50)

 

 

 

cus ill need to write a big fat code for all the barrow items

 

 

 

 

 

 

 

nevermind got it

[Darrel104]

I'm not too sure what your saying but i think your asking how to do this for multiple items but fit it all in one cell.

 

 

 

Try doing it calculation by calculation, then progress to fitting it all in one cell.

 

 

 

An simpler way would be to make a column for each bonus thing you need and then a total bonus column to add them all together and then you can just add that cell to the total number. Once you do that it should be a matter of copying and pasting.

 

 

 

 

 

 

 

it should look something like this:

 

 

 

 

 

 

 

Find what items are present in the cell with 3 different columns calculating it.

 

 

 

Cell B2: =if(A1 = "torg plate", 500,0)

 

 

 

Cell C2: =if(A1 = "torg belt", 200,0)

 

 

 

Cell D2: =if(A1 = "torg vest", 300,0)

 

 

 

Calculate the total values of the 3 cells.

 

 

 

Cell E2: =Sum(B2:D2) OR =B2+C2+D2

 

 

 

Sum up the total of everything.

 

 

 

Cell H2: =E2 +

 

 

 

 

 

 

 

 

 

 

 

Here is a sample of what it should look like with similar formulas to the ones last mentioned:

 

 

 

 

 

 

 

 

 

 

With the formulas i used showing(not same as ones above).

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

If they all reward the same amount try using the or function.

 

 

 

Here is an explanation from a website:

 

 

 

OR(logical_value_1, logical_value_2, ...logical_value_30)











Returns TRUE if at least one argument is TRUE. Returns the value FALSE if all the arguments have the logical value FALSE.. Logical_value_1, logical_value_2, ...logical_value_30 are conditions to be checked. All conditions can be either TRUE or FALSE. If a range is entered as a parameter, the function uses the value from the range that is in the current column or row.

 

 

 

 

 

 

 

Try using Insert > function , it can sometimes be a lot easier.

 

 

 

I think you are trying to do too much that you don't know try reading some parts of this.

 

 

 

http://www.usd.edu/trio/tut/excel/

 

 

 

 

 

 

 

 

 

 

 

Also if you don't already know there is a thing called a fill handle:

 

 

 

 

 

 

just click and drag to copy formulas and it automatically updates for the new locations. The reason I am telling you is because if you don't use it you will waste hours of time copying and adjusting formulas.