Using IF formula for dates
Closed
Ranaamani
Posts
1
Registration date
Wednesday August 26, 2015
Status
Member
Last seen
August 26, 2015

Aug 26, 2015 at 01:31 AM
Blocked Profile  Aug 26, 2015 at 05:55 PM
Blocked Profile  Aug 26, 2015 at 05:55 PM
Related:
 Using IF formula for dates
 Logitech formula vibration feedback wheel driver  Download  Drivers
 Date formula in excel dd/mm/yyyy  Guide
 Number to words in excel formula  Guide
 Excel marksheet formula  Guide
 Credit summation formula  Guide
1 response
OK, well I hope this fits in your scope. The logic for If in Excel is as follows: =If(logic_test, true, false)
So, what would that look like in a spreadsheet. Let us say that in Cell B1, we enter the following =if(A1="Red","it is red","It is not red")
Now if after we enter this formula, we put in cell A1 the value of "Red" (yes case sensitive), the we should get "it is red" in cell B1.
I hope this works. Tweek it to fit your needs!
I have said it once, I will say it again. IT!
So, what would that look like in a spreadsheet. Let us say that in Cell B1, we enter the following =if(A1="Red","it is red","It is not red")
Now if after we enter this formula, we put in cell A1 the value of "Red" (yes case sensitive), the we should get "it is red" in cell B1.
I hope this works. Tweek it to fit your needs!
I have said it once, I will say it again. IT!