Look at the greater value and use in formula
Solved/Closed
Gouws
Posts
45
Registration date
Sunday February 7, 2010
Status
Member
Last seen
April 15, 2012
-
Oct 1, 2010 at 02:44 AM
Gouws Posts 45 Registration date Sunday February 7, 2010 Status Member Last seen April 15, 2012 - Nov 5, 2010 at 02:32 AM
Gouws Posts 45 Registration date Sunday February 7, 2010 Status Member Last seen April 15, 2012 - Nov 5, 2010 at 02:32 AM
Related:
- Look at the greater value and use in formula
- Number to words in excel formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Excel grade formula - Guide
- Cardtext formula in word - Guide
2 responses
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Oct 1, 2010 at 05:20 AM
Oct 1, 2010 at 05:20 AM
=IF(OR(G27=0),0,(G27-(G30+max(G31,G32)+G35+G36)))
mistake in the formula
or(g27=0) this ok what i the other one in "or"
"or" should have two components
something like tis
or(g27=0,g27=3)
study and revise the formulas. regarding max use the part given by me
mistake in the formula
or(g27=0) this ok what i the other one in "or"
"or" should have two components
something like tis
or(g27=0,g27=3)
study and revise the formulas. regarding max use the part given by me
Gouws
Posts
45
Registration date
Sunday February 7, 2010
Status
Member
Last seen
April 15, 2012
Nov 5, 2010 at 02:32 AM
Nov 5, 2010 at 02:32 AM
TX, revised formula as suggested and it's working very good
