Forum Discussion

Ollie1785's avatar
Ollie1785
Copper Contributor
Feb 25, 2020
Solved

'If' statement help needed

What I trying to do may not be possible. I use the statement below to indicate what I want to do rather than being an accurate formula. What I need to to test a cell for a value (first set  of bracke...
excel
  • Savia's avatar
    Savia
    Feb 25, 2020
    In Excel this would read as:

    =IF('Start Sheet'!B5="L", IF('Score Input'!$D$3>='Course Card'!B$11, 1, 0), IF('Score Input'!$D$3>='Course Card'!B$6, 1, 0))
Savia's avatar
Savia
Iron Contributor
Feb 25, 2020
In Excel this would read as:

=IF('Start Sheet'!B5="L", IF('Score Input'!$D$3>='Course Card'!B$11, 1, 0), IF('Score Input'!$D$3>='Course Card'!B$6, 1, 0))
Ollie1785's avatar
Ollie1785
Copper Contributor
Feb 25, 2020

Savia 

 

Thanks Savia, I'll check it out and let you know if it does the job!!

 

Regards

Keith

Resources