Look at the greater value and use in formula
Solved/Closed
Gouws
Posts
45
Registration date
Sunday 7 February 2010
Status
Member
Last seen
15 April 2012
-
1 Oct 2010 à 02:44
Gouws Posts 45 Registration date Sunday 7 February 2010 Status Member Last seen 15 April 2012 - 5 Nov 2010 à 02:32
Gouws Posts 45 Registration date Sunday 7 February 2010 Status Member Last seen 15 April 2012 - 5 Nov 2010 à 02:32
Related:
- Look at the greater value and use in formula
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Grade formula in excel marksheet - Guide
- Formula to calculate vat in excel - Guide
- Number to words in excel formula - Guide
- Formula bar in excel - Guide
2 responses
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
1 Oct 2010 à 05:20
1 Oct 2010 à 05:20
=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 7 February 2010
Status
Member
Last seen
15 April 2012
5 Nov 2010 à 02:32
5 Nov 2010 à 02:32
TX, revised formula as suggested and it's working very good
