Posts by steven_c

can i text wrap formula's,

cause in formula mode there isn't enough room for it to fit on the whole page. in landscape mode.

i don't have enough room across but heaps of room downwards.

is there a way i can text wrap the formula.

thx

=IF(OR(G7="Yes",H7="Yes",I7="Yes"),"Yes","No")

i am using this formula and its not working....

I want to make it so that when the cells G7, H7, I7 all say yes then the other column will say yes.

If it says no in one of the cells the other column will say no.

how is this done?

is there a book in aus i can buy that has this type of stuff in it?

yep it worked, thx very much.

I want if to say yes for hatch and sedan and no for wagon.

Like a have column A1 which has hatch sedan and wagons in it and i want to create another column which says yes if its a hatch or sedan and no if its a wagon.

hope that its clearer.

ok, so i've designed IF statments for cars like this one:

=IF(AND(E7<7000,E7<7001),"Yes","No")

is this statement right, for saying that if the car is above $7000 it will say no and if the car below $7000 it will say yes.

Now i want to design an IF statment that specifys Yes or No. that says yes if its a hatch or sedan and no if its a wagon.

how would i do that, i tried putting letters in instead of the numbers and that didn't work.

also anyone that has msn that i can add them so they can help me if they want to.

thx in advance for any help.

thx i thought it would be something instead of the word sum..

last question for tonight then i'm off to bed.

how would you do a precentage decrease of 35%?

instead of =sum(A1:A2)

what would the formula be for A1 subtrating A2

ok thx guys got it now

anyone have msn that can help me?

so i can send my excel file over and they can see if its right?

i'm not sure if i should do the flate rate or stick with the $8 for every $200.

i would try both formula's.

so right now the:

=INT(A1/200)*8 (sub A1 as price) this is the $8 for every $200

=(8/200)*B2 (price) this would be the 4% flat rate

I'm just starting excel and would like to know a few things if someone is kind enough to help me. :cool:

I have made a column for cars and a column for the price in excel. Now my problem is that i want to create another column which would add the stamp duty which would be charged at the rate of $8 for every $200.

E.G

Car:
2003 Toyota Prado Grande

Price:
$80000

Stamp Duty:
what formula would i use for this? (at the rate of $8 for every $200 dollars.

look foward to hearing from u guys n' gals.