Excel Formula

Closed

stan - May 4, 2010 at 03:52 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 4, 2010 at 04:31 PM

in a separate cell, i have a number. If that number is greater than 11, i want a certain entry. if that cell is >6<11, i want another entry and if that cell is <6 i want a different entry. How would that formula look?

Excel Formula
Excel grade formula - Guide
Number to words in excel formula - Guide
Date formula in excel dd/mm/yyyy - Guide
Logitech formula vibration feedback wheel driver - Download - Drivers
Credit summation formula - Guide

1 response

Answer 1 / 1

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 4, 2010 at 04:31 PM

=IF(A1>11, "a1 is greater than 11", if(a1>6, "a1 is greater than 6 but less or equal to 11, "default so a1 must be less than or equal to 6"))

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel

How to calculate position (1st,2nd,3rd) in excel....?

Calculation of positions in excel

formulas for 1st and 2nd position in class

Similar discussions

Subscribe To Our Newsletter!