Excel cell equal another cell only if its a certain percentage

Closed
Matt - Dec 26, 2014 at 06:59 PM
vcoolio
Posts
1356
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
August 11, 2022
- Dec 30, 2014 at 05:57 PM
Hello,
I'm trying to have a cell equal another cell only if its a certain percentage (percentages are in another cell also, I tried "IFSUM" but its not allowing me. Anyone understand what I'm trying to do? Fo example, I want AB4 to Equal W4 only if its greater then 54& witch is in AA4 cell,

thank you


4 replies

you mean like this?
in cell AB4....
=IF(AA4>W4,W4,"")
0
No, sorry didn't work
0
why not?
Try explaining it differently
0
vcoolio
Posts
1356
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
August 11, 2022
250
Dec 30, 2014 at 03:34 AM
Hi Ray,

Sorry to intrude, but I think Matt may have meant this:-

=IF(AA4>54,W4,"")

with the formula placed in AB4.

I read Matt's post differently but.................


Again, apologies for intruding.

Cheers,
vcoolio.
0
No problem, intrude away. Its good to get another perspective.
However, I have to disagree with you.

He states that the percentage is in a 'certain cell', in this case, cell AA4.
The example he gave "54& witch is in AA4 cell", was an example only.

He also states that the comparison is between cell W4 and AA4.

His previous question, that was closed due to lack of clarity (not so in my opinion), that is eerily similar to this one.
The answer there was "=IF(B2>C2,A2*0.5,0)".

So, Matt. Back to you.
0
vcoolio
Posts
1356
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
August 11, 2022
250 > RayH
Dec 30, 2014 at 05:57 PM
Hi Ray,

Very true. I didn't see the closed post and reading your explanation above, I now see it differently again.

Yes, back to Matt.

Cheers people.
vcoolio.
0