Can anyone help me with what I missing in this formula for it to w

[M]

I have been looking at this for awhile and hate to spend hours staring at
what most likely is one little part that needs adjusting that I missing.

Here is my formula:
=IF(OR(AND(F16=6, G38<=3000), 300),(AND(F16=6, (OR(G38>3000, G38<=5599))),
(((G38-3000)*0.25)+300)), (AND(F16=6, G38>=5600),2840))

It tells me there is an error.

Now there was an alternate way that a previous person did the formula that I
tried to modify but without much luck. Which is part of why this is hard that
person is gone so I can't ask them what they were doing or trying to do.

Here was their formula
=IF(I38<>$F$16,0,IF(G38>5600,2840,IF(G38>1000,1000*0.5+(G38-1000)*0.25,G38*0.5)))

Here is what I tried to change it to but it tells me there are too many
arguments:

=IF(I38<>$F$16,0,IF(G38>5600,2840,IF(G38>3000,300+(G38-3000)*0.25), IF
(G38<=3000, 300)))

However if I remove back out the last section and do this it works (but of
course I need that second part that says if G38 = or is less then 3000 the
return the value of $300:
=IF(I38<>$F$16,0,IF(G38>5600,2840,IF(G38>3000,300+(G38-3000)*0.25)))

with this last formula if I put in $3000 for field G38 then it just comes
back saying False..so maybe in there somewhere I need a , and $300 but I
concerned that would throw off the rest.

Basically this is all based off if the value in G38 is 3000 or less return
$300, if the value is greater then 5600 then return $2840, and if the value
is grearer then 3000 or less then 5600 then it should be $300 plus .25 times
the amt over 3000.

I greatly appreciate any help!!

Thanks!
--
M
A+ Certified
8 yrs of IT Experiance in Support/Admin and working with Office applications

VB exp. based on self taught and what others have helped with.

Very proficient in Office applications as far as functionality.

 

[Jason Morin]

"Basically this is all based off if the value in G38 is
3000 or less return $300, if the value is greater then
5600 then return $2840, and if the value is grearer then
3000 or less then 5600 then it should be $300 plus .25
times the amt over 3000."

Try:

=IF(G38<=3000,300,IF(G38>5600,2840,300+0.25*(G38-3000)))

HTH
Jason
Atlanta, GA

 

[Tom Hayakawa]

How about this:

=IF(I38<>$F$16,0,IF(G38>5600,2840,IF(G38>3000,300+(G38-3000)*0.25,IF(G38<=3000,300,"Whatever"))))

Those pesky parens are always messing with your mind...