Notifications
Clear all
General Excel Questions & Answers
5
Posts
3
Users
0
Reactions
70
Views
Topic starter
Hi,
I was wondering if someone could help with an IF statement I'm struggling with.
The logic should be:
IF column C is CLEARPAY then add column H + I together, then figure out 20% of that value (H+I)
extra bonus - IF it is NOT clearpay - value should be 0.00
I've also added the sheet to this post. Thanks in advance.
Posted : 05/01/2022 8:23 am
No worksheet attached. Don't forget to click upload before posting. But it should be something like this assuming the function is in cell J1.
=if(C1="Clearpay",(H1+I1)*.02,0)
Posted : 05/01/2022 11:29 am
0.2 rather than 0.02 I think. 😉
Posted : 05/01/2022 12:41 pm
Topic starter
Thank you both, yes 0.2 was the correct figure as excel sees 1=100%.
All solved now 😀
Posted : 05/01/2022 1:09 pm
Thanks for catching my mistake Velouria!
Posted : 05/01/2022 5:28 pm
