PDIS
asked on
Excel formula needs to ignore empty cells
I need assistance with the following excel formula in cell f3
If (and b3, c3) b3-c3)
The intent is - Do only if there is a value in both b3 and c3
This formula would be copied down to the full column and then the values in the column would be averaged. I do not want to average values in that came from rows that did not have data in both columns B and C.
If (and b3, c3) b3-c3)
The intent is - Do only if there is a value in both b3 and c3
This formula would be copied down to the full column and then the values in the column would be averaged. I do not want to average values in that came from rows that did not have data in both columns B and C.
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thank you, both worked!
Microsoft Excel
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
=IF(COUNT(B3:C3)=2,B3-C3,"