Forum Discussion
Problem with IF Function
I am trying to calculate a number of cells and need to use the IF function. The calculation is IF H13>7.74, H13,SUM(H12,H13,H14, etc.) but if H10:I11 is blank then put H13. Here is the formula th...
In addition,
1) you may change
LEN(H10:I11) on SUM(H10:I11)
to check if all these cells are empty
2) Better to avoid cells merging, that could be side effect. Alternative is:
select couple of your cells->Ctrl+1->Alignment->Horizontal->Center Across Selection
That's not one click job as with merging, but much more reliable.