V VHaig New Member Apr 28, 2016 #1 Hi Can someone help me with this formula? =AVERAGEIF(Bookings!$A$2:$A$350,A2,(Bookings!$K$2:$K$35)) Works fine with cell A2 is populated but when it isn't I get the #DIV/0! error. What can I do to my formula so the cell will appear blank until A2 is populated? Thanks V
Hi Can someone help me with this formula? =AVERAGEIF(Bookings!$A$2:$A$350,A2,(Bookings!$K$2:$K$35)) Works fine with cell A2 is populated but when it isn't I get the #DIV/0! error. What can I do to my formula so the cell will appear blank until A2 is populated? Thanks V
Ashhu Active Member Apr 28, 2016 #2 Dear VHaig the below formula will show cell blank if there is error. Hope that's what you want. Let me know if my understanding in wrong. =IFERROR(AVERAGEIF(Bookings!$A$2:$A$350,A2,(Bookings!$K$2:$K$35)),"")
Dear VHaig the below formula will show cell blank if there is error. Hope that's what you want. Let me know if my understanding in wrong. =IFERROR(AVERAGEIF(Bookings!$A$2:$A$350,A2,(Bookings!$K$2:$K$35)),"")
V VHaig New Member Apr 28, 2016 #3 Ashhu said: Dear VHaig the below formula will show cell blank if there is error. Hope that's what you want. Let me know if my understanding in wrong. =IFERROR(AVERAGEIF(Bookings!$A$2:$A$350,A2,(Bookings!$K$2:$K$35)),"") Click to expand... Fantastic many thanks.
Ashhu said: Dear VHaig the below formula will show cell blank if there is error. Hope that's what you want. Let me know if my understanding in wrong. =IFERROR(AVERAGEIF(Bookings!$A$2:$A$350,A2,(Bookings!$K$2:$K$35)),"") Click to expand... Fantastic many thanks.
srinidhi Active Member Apr 28, 2016 #4 There are many way, you can use the CF & change the colour to the cell colour when an error appears or use the Iserror formula.
There are many way, you can use the CF & change the colour to the cell colour when an error appears or use the Iserror formula.
