Multiple If statements

italy16

New Member
Joined
May 9, 2014
Messages
29
Hello everyone - getting confused on some nested IF statements. Any help on writing the following formula would be awesome.

If a number is between 0 and 6, return the number (i.e. could be 1,2,3,4,5,6)
If a number is greater than 6, then return the number 12.

Thanks in advance
 

Some videos you may like

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
18,758
Office Version
2013
Platform
Windows
Where is the number ?? in a cell on the sheet ??
Assuming it's in A1
Code:
=IF(A1<=6,A1,12)
 

Watch MrExcel Video

Forum statistics

Threads
1,095,479
Messages
5,444,718
Members
405,298
Latest member
fxtrtr17

This Week's Hot Topics

Top