Is it possible for excel to display one of the two different false statements in a cell?

liabilityquek

New Member
Joined
Oct 17, 2021
Messages
25
Office Version
  1. 2019
Platform
  1. 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!
 

Attachments

  • Capture.PNG
    Capture.PNG
    31 KB · Views: 8

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"
in a nested IF the order is left to right
So when do you test C22
 
Upvote 0

Forum statistics

Threads
1,214,411
Messages
6,119,346
Members
448,888
Latest member
Arle8907

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top