Excel: IF then question
Closed
Jim
-
Nov 4, 2010 at 06:30 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Nov 4, 2010 at 09:06 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Nov 4, 2010 at 09:06 PM
Related:
- Excel: IF then question
- Excel marksheet - Guide
- Number to words in excel - Guide
- Excel free download - Download - Spreadsheets
- Kernel for excel - Download - Backup and recovery
- Excel date format dd.mm.yyyy - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Nov 4, 2010 at 09:06 PM
Nov 4, 2010 at 09:06 PM
first question try this
=IF(C31>400, C31*0.8, C31*0.9 )
second question
suppose A1 is either "low" "medium" or "high"(without quotes) then in B1 type this formula
=IF(A1="low",INT(C29/5),IF(A1="medium",INT(C29/3),IF(A1="high",INT(C29/2),"")))
C29 must have a number.
you can copy the formula in B1 down if you have values in A2 down .
=IF(C31>400, C31*0.8, C31*0.9 )
second question
suppose A1 is either "low" "medium" or "high"(without quotes) then in B1 type this formula
=IF(A1="low",INT(C29/5),IF(A1="medium",INT(C29/3),IF(A1="high",INT(C29/2),"")))
C29 must have a number.
you can copy the formula in B1 down if you have values in A2 down .