Mar 25 2021 08:15 AM
Hi,
I don't know what I am doing wrong here! I am testing for a value 'L' and want it to use the first calculation if it is set (U9) and the second (U3) if it isn't set to 'L'. Any ideas?
=IF(Start sheet !$B5="L"),IF(D5*Course Card!$U$9)/113*0.95),IF(D5*Course Card!$U$3)/113*0.95)
Thanks
Mar 25 2021 08:50 AM
Like this:
=IF('Start sheet'!$B5="L",D5*'Course Card'!$U$9/113*0.95,D5*'Course Card'!$U$3/113*0.95)
or, slightly shorter:
=D5*IF('Start sheet'!$B5="L",'Course Card'!$U$9,'Course Card'!$U$3)/113*0.95