If then statement for commission
Closed
Melissa
-
Dec 10, 2009 at 05:55 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Dec 10, 2009 at 08:01 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Dec 10, 2009 at 08:01 PM
Related:
- If then statement for commission
- More than 1 if statement excel - Guide
- Fenix internet on bank statement - Guide
- If statement with dates - Guide
- Which two sentences correctly describe the use of formulas in performing calculations in spreadsheets? all formulas written for a spreadsheet must follow certain rules, which we call syntax. when creating a formula in a spreadsheet, always start with an if statement. basic statements include numeric values and operators. if there are multiple operators, then the order of precedence starts with exponents. parentheses are used to isolate certain parts of the expression from the other parts. operations in parentheses are completed after the rest of the formula is evaluated. - Excel Forum
- My commission - Internet & Social Networks Forum
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Dec 10, 2009 at 08:01 PM
Dec 10, 2009 at 08:01 PM
the correct formula is
=IF(F4*0.2>750,750,F4*0.2)
those double quotes should not be there.
=IF(F4*0.2>750,750,F4*0.2)
those double quotes should not be there.
