I have a spreadsheet where I use the formula IF(BA21,”x”,”£0.00″). Basically, if the checkbox in BA21 is ticked, I get an x in the cell, otherwise I want to get a currency value of £0.00. I want to be able to replace that currency manually with e.g. £5.20 if I need to.
The problem here is I’m dealing with two different types of format in the same cell – text and currency. When I enter the currency value e.g. £5.20, the formatting then defaults to numeric then I get £5.
I’ve racked my brains to find another way to do this, but so far, nothing!
Do you have any suggestions as to how I can make this work in a tidier manner?
I run a lottery syndicate and this spreadsheet is a record of members contributions and weekly winnings. I have a “Week in play” field with a tick box. If that is ticked, then subsequent weeks show as blank by using the x or £0.00 value. If the tick box is unticked, what’s won that week is entered instead of the formula. It looks tidy, but the underlying code is messy.