Need IF Formula Help

J

jessicawalton

Hi Guys
Am attempting to write a formula with 2 ranges of outcome. Here's what I have so far and you can tell me what's wrong because I'm getting a #value! error message instead of an answer
=IF(AND(G4)<=0.5,sum=0),IF((G4)>=1.5,(sum=0.5*(F5))

If a specific cell has a response that is less than .5, I need it to return a zero answer. If that same cell's response is greater than 1.5, I need it to multiply .5 by another cell (f5) and return the answer

Any thoughts? Thanks in advance for your help. Please email any responses
[email protected]
 
F

Frank Kabel

Hi
not sure what 'sum' is but you may try something like
=IF(G4<=0.5,0,IF(G4>=1.5,F5*0.5,"not defined for 0.5-1.5"))
 
A

Anne Troy

=IF(G4<=0.5,0,IF(G4>1.5,0.4*F5,"xxx"))

xxx designated what you want if the value is BETWEEN .5 and 1.5, which you
didn't define.

<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
Hope this helps!
Anne Troy (better known as Dreamboat)
Author: Dreamboat on Word
Email: Dreamboat*at*Piersontech.com
Web: www.TheOfficeExperts.com
jessicawalton said:
Hi Guys:
Am attempting to write a formula with 2 ranges of outcome. Here's what I
Click to expand...
have so far and you can tell me what's wrong because I'm getting a #value!
error message instead of an answer:
=IF(AND(G4)<=0.5,sum=0),IF((G4)>=1.5,(sum=0.5*(F5)))

If a specific cell has a response that is less than .5, I need it to
Click to expand...
return a zero answer. If that same cell's response is greater than 1.5, I
need it to multiply .5 by another cell (f5) and return the answer.
 
J

jessicawalton

Hi (again) Frank

If it's a formula, it HAS to have "sum" in it, right?! Brain freeze

OK, to throw another wrinkle in the mix, the range of .5-1.5 that wasn't covered needs to do the following: if the range falls between .5 and 1.5, I need the cell to reflect (F5*5)-.25, so how do I list that as part of your formula?

Thanks again for such quick answers

Jessic

And Anne, your name should be Anne OF Troy!! heh

----- Frank Kabel wrote: ----

H
not sure what 'sum' is but you may try something lik
=IF(G4<=0.5,0,IF(G4>=1.5,F5*0.5,"not defined for 0.5-1.5")

--
Regard
Frank Kabe
Frankfurt, German


jessicawalton wrote
 
F

Frank Kabel

Hi Jessica
only use SUM in a formula then you want to sum something :) No
requirement to use it

For your other question use
=IF(G4<=0.5,0,IF(G4>=1.5,F5*0.5,F5*5-0.25))
 
Top