If/Then formula with multiple factors

where are you putting the formuals in another cell
so an IF ()
should work

if cell G35 is <0 but greater than -5.00% then Cell G23 times 98.5%. if cell G35 is <-5.0% but greater than -10.00% then Cell G23 times 95.0%. If cell G35 is <-10% then G23 times 90%

IF( AND(G35<0, G35>-0.05) , G23*0.985, IF( AND(G35 < -0.05 , G35 > -0.1 ) , G23*0.95, IF( g35 < -0.1, G23 * 0.9 , "does not meet criteria")))

I have not included -0.05 - as not used an equal =
so

> -0.05 < -0.05 will not include 0.05
same for -0.1

if G35 is 0 or greater than you will get a "does not meet criteria"

Does that work for you , if so then we can work out all the other criteria for your other rules
but before doing that , just want to make sure the rules are clear

Does that mean you can work out the rest of the formulas
or /and
you are happy with not picking up the -0.5 or -1 or will you use an equals somewhere ?

Okay so I am not sure I understand what you are saying about the -.05 and-.1. Are you saying it won't pick up those numbers if they are exact? Like it will not figure -.05 but it will figure any variance (example -.056 and -.049)?

only because of what you said

G35 is <0 but greater than -5.00%
if cell G35 is <-5.0% but greater than -10.00%

So
if greater than does not include -5
if less than does not include -5
so which of the rules do you want to apply to include -5
then all you do is make it
less than or equal < =
Greater than or equal > =
you need to decide which rule * 98.5 or * 95 you want -5 to be include in

sorry you are having trouble uploading a file
To attach a file to your post,
click "Go advanced" (next to quick post),
scroll down until you see "manage Attachments",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

so are all those formulas working OK as you want now ?

thanks for the coffee and Pastry - exactly what i like

=IF( AND(G36<0, G36>=250), F23*0.985, IF( AND(G36 <-250, G36>=-500 ), F23*0.95, IF( G36<-500, F23 * 0.9, "does not meet criteria")))

so this is testing if G36 <0 and is >=250 - which cannot be true
the AND is saying
the Value must be less than zero AND also must be greater or eqaul to 250 at the same time - which cannot happen

, but does that not need to be -250
AND(G36<0, G36>=- 250)
and again is it not supposed to be 250,000

=IF( AND(G36<0, G36>=-250000), F23*0.985, IF( AND(G36 <-250000, G36>=-500000 ), F23*0.95, IF( G36<-50000, F23 * 0.9, "does not meet criteria")))

AND

if cell G41 is >0 but less than or equal to 250,000 then Cell G23 times 95%. if cell G41 is >250,000 but less than or equal to 500,000 then Cell G23 times 85.0%. If cell G41 >500,000 then cell G23 times 80%

=IF( AND(G41>0, G41<=250), F23*0.95, IF( AND(G41 >250, G41<=500 ), F23*0.85, IF( G41 >500, F23 * 0.8, "does not meet criteria")))
should be
=IF( AND(G41>0, G41<=250000), F23*0.95, IF( AND(G41 >250000, G41<=500000 ), F23*0.85, IF( G41 >500000, F23 * 0.8, "does not meet criteria")))

I'm in UK so will be signing off soon and back again tomorrow late afternoon early evening UK timezone
and can help some more then

your welcome
if my assistance has helped, and only if you wish to , there is a reputation icon * on the left hand side - you can add to my reputation here