IF arguments

[dgavin]

How do I chnge this

=IF(Y5="","",IF(Dutch!D62<Controls!B6,Dutch!J37))

so it calculates

IF Y5="" then "" but if Dutch!D62 is less than Controls!B6 then Dutch!J37, but also if Dutch!D62 is greater than Controls!B6 then 10

Thanks

 

[Peter_SSs]

How do I chnge this

=IF(Y5="","",IF(Dutch!D62< Controls!B6,Dutch!J37))

so it calculates

IF Y5="" then "" but if Dutch!D62 is less than Controls!B6 then Dutch!J37, but also if Dutch!D62 is greater than Controls!B6 then 10

Thanks

Perhaps this?

=IF(Y5="","",IF(Dutch!D62< Controls!B6,Dutch!J37,10))

(Put a space after the < if you don't want the board to 'swallow' the rest of your formula )

 

[JamesW]

=IF(Y5="","",IF(Dutch!D62 < Controls!B6,Dutch!J37,IF(Dutch!D62 > Controls!B6,10)))

What do you want to happen if none of the above is true - Controls/Dutch cells are blank, or they equal each other?