Forum Discussion
Help with creating an "IF" formula
I need help in creating an IF formula. I am trying to create a formula that will populate the cell with the amount of Trip Pay is due to a traveler based on the number of miles that is entered in the...
Thanks for your help. To answer your question, there would never be a time that the number in A1 would be less than 26.
So we may keep zero for that
I had to change my formula to VLOOKUP and look up from a table. I know how to get the formula to work. I have a DROPDOWN list in C5 where you select a City from the 1st column of the table. The VLOOKUP is in D5 and populates the cell with the Mileage from the table that is assigned to the City.
The only problem I am having now is if C5 is blank (not used), then in D5 has #N/A displayed in D5. Is there a way to accomplish this action without #N/A being displayed if C5 is BLANK?
Hi Norman,
You may wrap you formula with IFNA() or IFERROR()
=IFNA(<your formula>, "")