I'm trying to create a formula....If the checkbox is "checked" in the Toledo column, then display the formula result that's in the price/ft column. If the checkbox is not checked then price/ft column is blank.
Any help is appreciated.
Thx
Joe
The following formula should be used in row 12... or adjusted to correct row number. Basically, it's looking to see if the Toledo checkbox is checked (checked boxes contain = 1, unchecked boxes = 0), if it is, then it will run the formula, if it's not the field will be blank, indicated by an empty string of text. ""
=IF([Toledo]12=1, [Loaded Rate]12 / [Collection Rate/Hr]12, "")
