# Excel cell equal another cell only if its a certain percentage

Closed
Matt - Dec 26, 2014 at 06:59 PM
vcoolio Posts 1410 Registration date Thursday July 24, 2014 Status Moderator Last seen May 23, 2024 - 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 responses

you mean like this?
in cell AB4....
=IF(AA4>W4,W4,"")
No, sorry didn't work
why not?
Try explaining it differently
vcoolio Posts 1410 Registration date Thursday July 24, 2014 Status Moderator Last seen May 23, 2024 262
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.
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.