| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Thank you Arvi, this works perfectly.
"Arvi Laanemets" wrote: Hi =IF(COUNT(A1:D1)<4,"#N/A",SUM(A1:D1)) -- When sending mail, use address arvil<attarkon.ee Arvi Laanemets "Andy T" wrote in message ... This is bugging me so if anyone can help I'd be very grateful. If I have a range of numbers, say A1:D1 and I have a very simple formula to sum those numbers is it possible to force the result to represent say "#N/A" if one of the numbers in my range A1:D1 is missing. In other words, unless I have a figures in each of the cells A1:D1 I don't want the calculation to happen. Many thanks as always -- Andy T |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula query | Excel Discussion (Misc queries) | |||
| Query of External Data | Excel Discussion (Misc queries) | |||
| Converting an Excel formula to an Access query formula | Excel Discussion (Misc queries) | |||
| How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
| formula query | Excel Discussion (Misc queries) | |||
Hybrid Mode
