Whats The Best Way? (Excel Related)

[LeftfieldTilt]

Sup you clever people I have a Q for you....

I have an Excel sheet that I need to calculate something in.

I need to take a figure I have, check it against somthing (lets call it x) and then multiply the figure by 1 of 3 percentages depending on what x is

All replies are appreciated

Thanks

 

[Fr0dders]

your going to need to use the IF statement

i could try and write a formula, but its going to be hard without seeing your spreadsheet or the values your using

so instead read this

http://www.personal-computer-tutor.com/IFstatement.htm

2nd part of the tutorial

http://www.personal-computer-tutor.com/if1.htm

3rd part

http://www.personal-computer-tutor.com/if2.htm

 

[LeftfieldTilt]

I have made an excel sheet with an example of what I have and what i need to do.

email only at the mo, I'll send it to whoever thinks they can help

Thanks

 

[The_KiD]

email in trust.

 

[Gopher_By_Fende]

if you send the sample to me i'll have a go, no promises though

gopher_by_fender AT gopherbyfender DOT com

 

[LeftfieldTilt]

Sent.

Cheers