LinkBack URL
About LinkBacks
I have =IFERROR(U281<0,0, IF(U281>0,U275-U280))
Problem is uf U275 and/or 280 is blank, the IF(U281>0,U275-U280)) returns false and not dash.
Cell for this formula is U282 fyi.
I have =IFERROR(U281<0,0, IF(U281>0,U275-U280))
Problem is uf U275 and/or 280 is blank, the IF(U281>0,U275-U280)) returns false and not dash.
Cell for this formula is U282 fyi.
how about
=IFERROR(IF(U281<0,0,IF(U281>0,U275-U280,"-")),"-")
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
try
=IFERROR(IF(U281<0,0,IF(U281>0,U275-U280,0)),0)
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
This?
Please Login or Register to view this content.
-If the problem is solved, please mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved".
-Always upload a workbook before start your question
To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.
+++ If my answer(s) helped you, please add me reputation by click on * +++
You guys are awesome, please check out this spreadsheet, this is what I am having problems with, it explains everything there.
A slight correction in your formula.
For col. e try this
IF(OR(VALUE($E13)=0,VALUE(E17)=0),0,IF(15>=$E13*E17, 15, IF(15<=$E13*E17,$E13*E17,IF(15>=E17,E17+E18))))
And for Col g
=MAX(15,IF($C$2="NO STACK/SNOWBALL",G101-(G106)))
Rgd
RT
If my answer(s) helped you, please add me reputation by click on *
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks