I currently have this formula in my cell:
=IF(F9+B10-C10-D10-E10>1260, "1260") That works great...except when the sum comes out to less than 1260, I want it to just keep the sum there and not make it 1260.
In other words, if F9+B10-C10-D10-E10 = greater than or equal to 1260 it would always enter 1260...YES!
If F9+B10-C10-D10-E10 = less than 1260 it would just use that calculated amount.
Please help.
Thanks!!!
=if(f9+b10-c10-d10-e10>1260;1260;f9+b10-c10-d10-e10)
When I say semicolon, u say comma!
Try this.
Formula:
Please Login or Register to view this content.
If posting code please use code tags, see here.
That didn't work...
(Sorry, this was directed to L-Drr's post, not Dorie's)
Last edited by cryssy29; 08-02-2013 at 12:51 PM.
Hi,
"That didn't work..."
Norie's answer looks perfectly good to me. Perhaps you could expand on your comment a little and explain why it didn't work? What result did it give? What result were you expecting?
Regards
Norie,
That's "almost" there...but in occurances where it's less than 1260, it's still entering 1260 and not the lesser amount...which messes up the following
1260 - OK
1259 - OK
1260 - NO...This should be taking the 1259+B10-C10-D10-E10. For my calculations it should be: 1259+10.5-0-0-0 = 1269.5. Since that's over 1260, I want it to keep the 1259 and only use 1259 for the remainder of the calculations down the column...and so on.
Does that make sense?
Sorry that doesn't add up.
1269.5 is more than 1260 so, according to your request, should return 1260.
If you wanted to return 1259, the value in F9, then that kind of changes things quite a bit (completely?).
Last edited by Norie; 08-02-2013 at 12:50 PM.
Sorry, when I put the formula in the formula bar I receive the "Your formula contains an error" message. For additional detail see my response to Norie below.
(Again, I'm referring to L-Drr's and XOR LX's followup), not Dorie.
Last edited by cryssy29; 08-02-2013 at 12:55 PM.
Norie, I guess I'm not explaining this correctly...
If the value is 1260 or over I want it to show 1260 in F10.
If the value is under 1260 I want it to show that lesser amount in F10 so that calculations following (F11, F12, F13, etc.) will use the lesser amount.
That's what the formula does.
Earlier I posted this
Doesn't that work either?Originally Posted by L-Drr
Edit: saw your edit, but I'm really surprised that it doesn't work... maybe it's different excel 2011 semantics/syntax?
Last edited by L-Drr; 08-02-2013 at 12:58 PM.
Ahhh now I see! You want to keep F9, not the whole sum!
Try this: =if(f9+b10-c10-d10-e10>1260;1260;f9)
never mind...got it.
Last edited by cryssy29; 08-02-2013 at 01:10 PM.
L-Drr
If the OP wants to keep the F9 that kind of contradicts the original post that said to keep the result of the calculation if the result is under 1260.
cryssy29
Attach a workbook rather than an image.
Yup true, but in post #6 the question seems to have changed (as I see now you already noticed in post #7)
Actually, I think I know what the problem is - F9 needs to be absolute not relative as it was in the original formula you posted.
Is that correct?
Formula:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks