If function command
Hello,
What I'm trying to do with excel is the following.
If the cell K2 has a value that is less than 1 then i want the formula to return the value 1000 and if K2 is 1 or larger then it should return whatever is in AX2.
I've tried using the following formula:
=IF(K2<1;1000;AX2)
I even tried setting a cell B2 = 1000
and doing the following:
=IF(K2<1;$B$2;AX2)
It doesn't work, can any1 see why?
try: =IF(K2<1,1000,AX2)
ups, I read first line only
Why it doesn't work for you?
If B2 =1000 this is the same like your first formula
Last edited by sandy666; 05-01-2017 at 04:03 PM.
Assuming that your regional delimiter is semicolons (and not commas), your formula should have worked.
Possible reasons it did not work.
1. The value in K2 is set as text and is not being seen as a number.
2. The K2 you refer to is on a different sheet and you need to reference that sheet.
3. Numerous other possibilities that I can't even think of without seeing an example sheet.
Upload an example sheet (Go Advanced>Manage Attachments)
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks