liabilityquek
New Member
- Joined
- Oct 17, 2021
- Messages
- 25
- Office Version
- 2019
- Platform
- Windows
Hi All
I would like to have one of the two different false statements to be displayed in cell C29. Not sure whether nested if is applicable for this criteria.
1. IF(OR($C$16="Sole Proprietorship",$C$16="Partnership",$C$16="Limited Partnership",$C$16="Limited Liability Partnership"),"No Credit Limit to be given due to Entity Type", (40/100)*$C$17)
2. IF($C$22>=(5/100*$C$17),"No credit to be given as litigation is >= 0.05% of paid up capital",$C$22)
Thanks for the help in advance!
I would like to have one of the two different false statements to be displayed in cell C29. Not sure whether nested if is applicable for this criteria.
1. IF(OR($C$16="Sole Proprietorship",$C$16="Partnership",$C$16="Limited Partnership",$C$16="Limited Liability Partnership"),"No Credit Limit to be given due to Entity Type", (40/100)*$C$17)
2. IF($C$22>=(5/100*$C$17),"No credit to be given as litigation is >= 0.05% of paid up capital",$C$22)
Thanks for the help in advance!