I have looked but cannot see if this has been asked before...
What I need to do is:
If Sheet1 C9 = 0 then all of the cells in Sheet2 B20:B30 = 0 otherwise use the indivdual cell formula
All of the individual cells in the range of B2:B30 have various formulas that look at different values within the sheet, so to get round this for the time being, I have put the forumla below into each cell.
=IF(Parameters!C9=0,0,B21*3)
Is there a way to apply an IF statement to a range a of cells, and if so, what is it.
Thanks in advance!
Bookmarks