https://mudcat.org/thread.cfm?threadid=161300

16 messages

10 Jan 17 - 07:32 AM (#3831652) Subject: RE: Excel spreadsheets From: DMcG There is an AND function but not an AND operator, so you have tonwrite it as AND (x,y) |

10 Jan 17 - 08:48 AM (#3831667) Subject: RE: Excel spreadsheets From: DMcG IF (AND ($AN="ii", $Cn="b"), formula- $En, formula) Or something like that - i dont have excel here! |

10 Jan 17 - 10:40 AM (#3831691) Subject: RE: Excel spreadsheets From: SPB-Cooperator If you are dragging down formulas, it is also useful to have an error trap condition. |

11 Jan 17 - 06:32 AM (#3831873) Subject: RE: Excel spreadsheets From: Steve Shaw Just send me all your bank details, sort codes and PIN numbers, Mo, and I'll sort it all out for you in no time! 😈 |

12 Jan 17 - 05:21 AM (#3832022) Subject: RE: Excel spreadsheets From: Mr Red 😊 |

13 Jan 17 - 10:24 AM (#3832334) Subject: RE: Excel spreadsheets From: Mrrzy This is what databases are for... kidding! |