UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Hide Contents Of Cell Returning Calculation, Office 2013    
 
   
bakersburg9
post Jul 24 2019, 03:56 PM
Post#1



Posts: 5,573
Joined: 2-November 04
From: Downey, CA


I have a column that contains a formula that calculates whether a manager qualifies for a bonus - if they DON'T, then the cell displays "FALSE" - obviously, I can't just write an edit/replace macro to replace false with a dash, or nothing, etc - the formula is very long:

CODE
=IF(A:A=1,IF(((B2-C2)/B2)>0.329,((B2-D2)*0.005)),IF(A:A=5,IF(((B2-C2)/B2)>0.329,((B2-D2)*0.005)),IF(A:A=4,IF(((B2-C2)/B2)>0.349,((B2-D2)*0.005)),IF(A:A=3,IF(((B2-C2)/B2)>0.349,((B2-D2)*0.005))))))


any help would be greatly appreciated....

Steve
Go to the top of the page
 
Zaddicus
post Jul 25 2019, 06:33 AM
Post#2



Posts: 137
Joined: 3-April 19
From: Cardiff


Hi there,

Hopefully if I read this correctly you want the cell to display "-" instead of "FALSE"
I've amended your formula to add another nested IF, hopefully it does what you need (unable to actually check because no sample data), if not just let me know and I'll try something different for you

CODE
=IF(IF(A:A=1,IF(((B2-C2)/B2)>0.329,((B2-D2)*0.005)),IF(A:A=5,IF(((B2-C2)/B2)>0.329,((B2-D2)*0.005)),IF(A:A=4,IF(((B2-C2)/B2)>0.349,((B2-D2)*0.005)),IF(A:A=3,IF(((B2-C2)/B2)>0.349,((B2-D2)*0.005))))))=FALSE,"-")


hth,

--------------------
~ Castiel


Skype: live:castielswift
Go to the top of the page
 
bakersburg9
post Jul 25 2019, 02:03 PM
Post#3



Posts: 5,573
Joined: 2-November 04
From: Downey, CA


Zaddacus,
Thanks !!!!! :code: I tried different varitions, nothing worked - THANKS SO MUCH!!! cool.gif

Steve
Go to the top of the page
 
Debaser
post Aug 1 2019, 07:50 AM
Post#4



Posts: 147
Joined: 11-October 18



Out of curiosity, what do you think this part is doing:

IF(A:A=1,

?
Go to the top of the page
 
bakersburg9
post Aug 1 2019, 02:23 PM
Post#5



Posts: 5,573
Joined: 2-November 04
From: Downey, CA


Debaser,

Is the value of column A equal to "1" ?
Go to the top of the page
 
Debaser
post Aug 1 2019, 03:59 PM
Post#6



Posts: 147
Joined: 11-October 18



Which part of column A? Current row, all of it, or something else?
Go to the top of the page
 
bakersburg9
post Aug 3 2019, 04:46 PM
Post#7



Posts: 5,573
Joined: 2-November 04
From: Downey, CA


Debaser,
Current row. I didn't write this formula... I asked the same question.....they have this REALLY long IF formula, involving their divisions...and all divisions now use the same formula for counting bonuses.. except division 7 ...so why not use a simple IF construct where the basically have the standard method, ELSE the method for division 7.... I think some Excel guru set up years ago, and they don't know how to fix it

This post has been edited by bakersburg9: Aug 3 2019, 04:53 PM
Go to the top of the page
 
Debaser
post Aug 5 2019, 03:24 AM
Post#8



Posts: 147
Joined: 11-October 18



If it's the same row, it should just be IF(A2=1,
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    17th October 2019 - 03:30 PM