'IF' Statement

Copper Contributor

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

2 Replies

@Ollie1785 

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

Thanks - @Hans Vogelaar