Forum Discussion
If/Then Formula Not Drawing Across Sheets
I have an If/Then formula setup within a worksheet that is as following: =IF(B23="Installation", C23=0, IF(B23="1m Pickup", C23=Rates!$B$2, IF(B23="2m Pickup", C23=Rates!$B$3, IF(B23="1m Bucket",...
I guess that formula shall be in C23 as
=IF(B23="Installation", 0, IF(B23="1m Pickup", Rates!$B$2, IF(B23="2m Pickup", Rates!$B$3, IF(B23="1m Bucket", Rates!$B$4, IF(B23="2m Bucket", Rates!$B$5, IF(B23="1m Crane", Rates!$B$6, IF(B23="2m Crane", Rates!$B$7, IF(B23="High Time", Rates!$B$8))))))))
