Excel cell equal another cell only if its a certain percentage
Closed
Matt
-
Dec 26, 2014 at 06:59 PM
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - Dec 30, 2014 at 05:57 PM
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - Dec 30, 2014 at 05:57 PM
Related:
- Excel cell equal another cell only if its a certain percentage
- Excel marksheet percentage formula - Guide
- If cell contains date then return value ✓ - Office Software Forum
- Excel send value to another cell - Guide
- Excel formula to subtract one cell from another - Excel Forum
- Clear only the formatting from the selected cell (leaving the content) - Guide
4 responses
vcoolio
Posts
1411
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 6, 2024
262
Dec 30, 2014 at 03:34 AM
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.
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.
The answer there was "=IF(B2>C2,A2*0.5,0)".
So, Matt. Back to you.
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.
vcoolio
Posts
1411
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 6, 2024
262
>
RayH
Dec 30, 2014 at 05:57 PM
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.
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.
