I'm trying to construct a spreadsheet and I'm having trouble with a formula.
I want the formula to be able to do the following:
<!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:DoNotOptimizeForBrowser/> </w:WordDocument> </xml><![endif]-->IF cell e3 is greater than 3 and cell m3=true or cell n3=true show 'true' if not show 'false'
Try as I might, I just can't get it to work.
Thanks in advance for any responses.
Will M
I want the formula to be able to do the following:
<!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:DoNotOptimizeForBrowser/> </w:WordDocument> </xml><![endif]-->IF cell e3 is greater than 3 and cell m3=true or cell n3=true show 'true' if not show 'false'
Try as I might, I just can't get it to work.
Thanks in advance for any responses.
Will M