-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
=ifa1
-
A
Conditional Result in Excel
Hello guys I need your help to write the correct formula. I will explain my concern in a simplified example: CELL | Value A1 | 500 A2 | =if(A1>100, "Error: Too...- Abdullah_h
- Thread
- =ifa1 =ifa1100 cell error simplified
- Replies: 9
- Forum: Excel Questions
-
A
Formula to create points
Good Day, This formula works for adding a ticket for every full 1000 =IF(A1<=1000,INT(A1/100),10+INT((A1-1000)/1000)) Is it possible to change above formula base on below rules? Many Thanks Every 100= 1point Between 100 to 1.000= 10point Every 1,000= 1point Between 1.000 to 10.000= 10point...- asyamonique
- Thread
- =ifa1 adding formula full ticket
- Replies: 30
- Forum: Excel Questions
-
M
Combing cells
Good afternoon Excel gurus , If I have to columns in one column I have 3M Libor in the column next to it 1.18. How do I make the 3rd column read 3M Libir +1.180%? I tried =If(A1 "&text("B1,000%") Its not working. Anyone got anything better? Thanks in advance- Markiup
- Thread
- &textb1 000% =ifa1 column read
- Replies: 6
- Forum: Excel Questions
-
L
date with if() is not working
Hi I have this formula =IF(A1<1/9/2016,"",A1) which does not work. However, if i save the date 1/9/2016 in a cell, lets say H1 and do this formula again but instead of the date 1/9/2016, i put H1. thank you<h1,"",a1)....<h1,"",a1)...<h1,"",a1).<h1," ",a1) <h1,"",a1), it="" will="" work,=""...- lezawang
- Thread
- =ifa1 date formula working
- Replies: 1
- Forum: Excel Questions
