VALUE Error

[stephcohen]

I am getting a VLAUE error in cell F17 with a new formula I am trying and I can't find where the error is. Can you see it? The sheet is attached.

This is the raw formula
=IF(F15<(0.5*$J$3),(($J$3*0.25)-F14),IF(F15<(0.75*$J$3),(($J$3*0.25)-F14)+F16)),IF(F15>(0.25*$J$3),0)

[etaf]

(($J$3*0.25)-F14)+F16))

and no false or ) ending
=IF(F15<(0.5*$J$3),(($J$3*0.25)-F14),IF(F15<(0.75*$J$3),((($J$3*0.25)-F14)+F16),IF(F15>(0.25*$J$3),0,"what to do if false")))

updated the sample - quite complicated - so did not look closely to be honest, added formula above - removes the error

[stephcohen]

Thank you for your help. If you would be willing to take another look, I am curious how to make this embedded IF statement work. Conversationally, here is what I want it to do:
If the value of f15 is less than 50% of J3, "do this"
If the value is less than 75% of J3 (but more than 50%), "do this"
If the value of f15 is equal to or more than 75% of J3, then the answer is 0

I thought I had the structure right, but you are suggesting that I have an additional statement at the end and I am not sure what that would be.

[The_Snook]

Hi stephcohen,

Does this work for you?

=IF(F15<(0.5*$J$3),(($J$3*0.25)-F14),IF(F15<(0.75*$J$3),(($J$3*0.25)-F14)+F16,IF(F15>=(0.75*$J$3),0,"")))

For info - Your second IF statement didn't have a 'value if false'. I corrected your last IF statement to be >= as per your instruction above and adjusted the value to 0.75 rather than 0.25 (As etaf points out though, the final IF criteria isn't really necessary as it will become the default option if the criteria for the other IF statements aren't met). You didn't have a 'value if false' specified for your final criteria so I've input blank (""). Also, as a quick visual check and tip, your formula contained three IF statements so I would have expected it to end with three closed brackets (yours had one).

Hope this helps,

Snook

[etaf]

=IF(F15<(0.5*$J$3),(($J$3*0.25)-F14),IF(F15<(0.75*$J$3),((($J$3*0.25)-F14)+F16),IF(F15>(0.25*$J$3),0,"what to do if false")))

if its less than 50% - TRUE , then IF less than 75% - TRUE - so now it must be more than 75%, as no other option - so you dont need the extra IF
so taking that info and using the IF

=IF(F15<(0.5*$J$3),(($J$3*0.25)-F14),IF(F15<(0.75*$J$3),((($J$3*0.25)-F14)+F16),0))

But you seem to be taking > 0.25% , so that maybe a typo, but as mentioned its not needed , as if its NOT < 50 or <75 - then it must be greater than 75
Possible a blank cell - which will be seen as zero

=IF( F15="", "", IF(F15<(0.5*$J$3),(($J$3*0.25)-F14),IF(F15<(0.75*$J$3),((($J$3*0.25)-F14)+F16),0)))
ignores blank cells

[stephcohen]

You did it! Thank you! It was impossible for me to see. Thank you.

[etaf]

you are welcome