Skip to content

Instantly share code, notes, and snippets.

@luckyshot

luckyshot/gist:5147735

Last active December 14, 2015 20:59
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save luckyshot/5147735 to your computer and use it in GitHub Desktop.
Save luckyshot/5147735 to your computer and use it in GitHub Desktop.
Download ZIP
Google Spreadsheets (Excel) - Nested IFs formula
Raw
gistfile1.as
=($C5*if(CZ25>3, if(CZ25>5,if(CZ25>10,if(CZ25>25,if(CZ25>30,32,16),8),4),2),1)
+$C5*if(CZ26>3, if(CZ26>5,if(CZ26>10,if(CZ26>25,if(CZ26>30,32,16),8),4),2),1)
+$C5*if(CZ27>3, if(CZ27>5,if(CZ27>10,if(CZ27>25,if(CZ27>30,32,16),8),4),2),1)
+$C5*if(CZ28>3, if(CZ28>5,if(CZ28>10,if(CZ28>25,if(CZ28>30,32,16),8),4),2),1)
+$C5*if(CZ29>3, if(CZ29>5,if(CZ29>10,if(CZ29>25,if(CZ29>30,32,16),8),4),2),1)
+$C5*if(CZ30>3, if(CZ30>5,if(CZ30>10,if(CZ30>25,if(CZ30>30,32,16),8),4),2),1)
+$C5*if(CZ31>3, if(CZ31>5,if(CZ31>10,if(CZ31>25,if(CZ31>30,32,16),8),4),2),1)
+$C5*if(CZ32>3, if(CZ32>5,if(CZ32>10,if(CZ32>25,if(CZ32>30,32,16),8),4),2),1)
+$C5*if(CZ33>3, if(CZ33>5,if(CZ33>10,if(CZ33>25,if(CZ33>30,32,16),8),4),2),1)
+$C5*if(CZ34>3, if(CZ34>5,if(CZ34>10,if(CZ34>25,if(CZ34>30,32,16),8),4),2),1)
+$C5*if(CZ35>3, if(CZ35>5,if(CZ35>10,if(CZ35>25,if(CZ35>30,32,16),8),4),2),1)
+$C5*if(CZ36>3, if(CZ36>5,if(CZ36>10,if(CZ36>25,if(CZ36>30,32,16),8),4),2),1))/1000
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment