If statement

[tata_ancona]

Hi all,

I have a a performance log spreadsheet where we updated every day less weekends. I created the following formula so the it gets the average for the weekends so on Monday when they fill the flowmeter readings, the spreadsheet will calculate itself. It is working perfectly However when it is Friday the result is negative which makes the graphs all funny.

=IF(B968="Friday",(C971-C968)/3,IF(B968="Saturday",D967,IF(B968="Sunday",D967,IF(AND(C969="",C971=""),NA(),C969-C968))))

Can you guys see any way I could add any other if (C971="", NA()). My idea is while I do not put any information in C971 the first if statement should not work.

I do not know if I made myself clear. so please let me know if you have any question before helping me out.

Thanks

[Pepe Le Mokko]

Like this?
=IF(C971="", NA(),(IF(B968="Friday",(C971-C968)/3,IF(B968="Saturday",D967,IF(B968="Sunday",D967,C969-C968)))))

[tata_ancona]

It did work, Thanks!!!