| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Display
I have made a sheet for show ticket sales
Col A = Ticket No. Col B = Name Col C = Ticket Cost (£6) Col D = Paid. Also Col C shows £6 in every row due to the function =IF(D13,0,6) I would only like the £6 to be shown in C1 if there is text in B1. OTW it is to remain blank. I've tried everything to achieve this but can't. Over to you please |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting capability for 20+ conditions not just 3. | Excel Discussion (Misc queries) | |||
| Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
| Accessing values in points collection of chart & conditional display | Charts and Charting in Excel | |||
| Why won't my conditional formatting display in the cell | Excel Discussion (Misc queries) | |||
| Conditional display of a .jpeg file? | Excel Discussion (Misc queries) | |||
Threaded Mode
