Ian -
Dec 14, 2009 at 08:04 AM - Latest reply: Alli
- Nov 29, 2010 at 02:18 PM

- Excel Sum Greater than but Less Than
- Excel sum value... [Solved] (Solved) » Forum - Excel
- Excel summing up values of scattered data [Solved] (Solved) » Forum - Excel
- Excel - Use the IF statement with Data Validation » How-To - Excel
- If date in cell is greater than date in cell [Solved] (Solved) » Forum - Office Software
- Excel dates greater than todays date » How-To - Excel

Best answer

Mabey you have an answer already but for others this will help with other things. Use an AND statement

=IF((AND($B$5-$B$10<60,$B$5-$B$10>30)),C10,0)

=IF((AND($B$5-$B$10<60,$B$5-$B$10>30)),C10,0)