Hi All,
Please see the below formula...when I try to copy it down, I am receiving the #VALUE! error.
Could someone help me with a solution that will hide this?
Thanks!!!
=IF(J16="Split Increase",H16-(I16*0.5),IF(J16="Give Back",G16,IF(J16="Roll Back",G16-(G16*0.05),IF(J16="No Change",H16))))
Without knowing the kinds of values in G16:I16...
A #VALUE! error would typically occur if one of those cells contained text.
Consequently, you could either prevent text from being entered in
those cells or edit your formula to convert text to zeros:
Example:
Does that help?
Please Login or Register to view this content.
Works Great
Just two alternatives:
1) What if it is neither you might want to defineAnd aonther apprach:Please Login or Register to view this content.
Please Login or Register to view this content.
Looking for great solutions but hate waiting?
Seach this Forum through Google
www.Google.com (e.g. +multiple +IF site:excelforum.com/excel-general/ )
www.Google.com (e.g. +fill +combobox site:excelforum.com/excel-programming/ )
Ave,
Ricardo
=IF(J16="0",H16,G16+J16)
Thanks...I don't know why I can't grasp this concept
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks