Hi,
I am trying to write a formula that states If cell a1 = 4, then a1*5, if cell a1= 3, then a1*4 if a1 1 doesn't = 4 or 3, then a1 1*6.
I'd appreciate any help you could provide.
Hi,
I am trying to write a formula that states If cell a1 = 4, then a1*5, if cell a1= 3, then a1*4 if a1 1 doesn't = 4 or 3, then a1 1*6.
I'd appreciate any help you could provide.
Last edited by Janie; 04-06-2009 at 03:31 PM.
=if(a1=4;a1*5;if(a1=3;a1*4;a1*6))
Never use Merged Cells in Excel
Wellcome to forum. Please make your names more precise when posting new question and don't forget to make it [solced] when you are satisfied with your answer![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks