Hi all,
I'll try to explain:
I have a value in cell A1 And another in B1. This formula works, but only for if the difference is more than the value of A1:
=IF(B1-A1>A1*100%,((B1*50%)),"")
What I want is a staggered range.
Thanks in advance.
I'll try to explain:
I have a value in cell A1 And another in B1. This formula works, but only for if the difference is more than the value of A1:
=IF(B1-A1>A1*100%,((B1*50%)),"")
What I want is a staggered range.
- If B1 is "between" 100% & 125% *(A1), how would I show that?
- Then How do I show:
if (B1-A1) is "between" 100% & 125% *(A1), 'show' 50% *(A1) .... ELSE if (B1-A1) is "between" 125% & 150% *(A1), 'show' 55% *(A1) ... ELSE if (B1-A1) is "between" 150% & 175% *(A1), 'show' 60 *(A1)
Thanks in advance.