Hi Is it possible to use text cells in if/else statements in Calc? Im using Calc to do a household budget spreadsheet & am including a sheet which will track and chart all electricity bills, for instance, through the year. Can you have an If statement that says, for Januarys sheet, if A1=Electricity then print the value in B1? Ive tried something along the lines of =IF($Jan.A1='Electricity';$Jan.B1;0) but it hasn't worked.
Anyone got any suggestions? Thanks Dermot --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
