FALSE Statement

A

abacon1960

Board Regular
Joined
Jul 28, 2014
Messages
54
=IF(O16="X","Incl. @ Sub Proposal",IF(P16="X",0) It comes out as FALSE if neither of the X boxes is checked. I want it to be blank. As in $ -. Cell is formatted in Accounting mode.
 
Sort by date Sort by votes
Try this.

=IF(O16="X","Incl. @ Sub Proposal",IF(P16="X",0,""))
 
Upvote 0
You must log in or register to reply here.

Similar threads

drom
  • Question Question
Path Exists if shared and comes as \\... not as C:\...
Replies
1
Views
101
Tupe77
T
D
  • Question Question
Help with "list source must be delimited list, or a reference" error
Replies
1
Views
200
myall_blues
myall_blues
J
  • Question Question
INDEX with small formula issue
Replies
5
Views
159
Cubist
Cubist
R
  • Solved
How to shade rows alternately in all sheets but two
Replies
4
Views
154
Refugar
R
D
  • Solved
Comparing characters in two strings and looking for a difference
Replies
2
Views
227
dgparryuk
D

Share this page

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