I am making a spreadsheet for scoring a mahjong game and want to put into a cell the amount “Sue” is paid by" Dom" if she goes out.
Each player is either East, South, West or North, and whoever is East pays or receives double.
So if "Sue goes out then all players pay her (her Score X) but if she is East they all pay double or if another player is East, that player pays double.
I think basically it is this
(If Sue is OUT) and ((if either Sue or Dom is EAST then 2*X) if not then X) if Sue not OUT then blank.
But I can’t work out the proper notation with so many ifs. Is it posible please.
Regards
Welcome to @Cymbaline !
I think you mean something like a table like this? - mahjongScore.ods (11.0 KB)
Yes sort of. I have attached the spreadsheet as far as I have got. Its the table at the bottom that I cant work out. I’ve tried this for Value A without success. =IF(C24=“1”,IF(OR(C3="",E3=""),2*M28,M28),""))
Mahjong scorer 2 calc.ods (39.7 KB)
PS. Going Mahjong means going out.
Only the coloured cells may require user input and I have entered some data to check if it works OK.
Thanks for your help so far I realise it is all a bit complicated.
Regards Chris
Thanks for your help guys. I have managed to work it out.
=IF(C24=1,(IF(OR(C3="*",E3="*"),2*M28,M28)),"") [preformatted text marks added by LeroyG]
I just had the brackets wrong and quotes around the 1 shouldn’t have been there.
Seem to work OK now.