IF, AND, OR Formula Help

[scottschneider]

2.5
	2.5
Modifier	Modifier
HQ	UP
HQ	UN

Hello! So I have a spreadsheet I use for invoicing and depending on which box I input the hours in (2.5), determines what modifier I need to use (UP or UN). So I was wondering if anyone could help me generate a formula that if I input tie in the upper box it returns the value of UP or if there is a value in the lower box it would return the value of UN and if there is no value, it would just remain empty. 

Thank You!

[#2 · Accepted solution]

@scottschneider 

The upper box value is in cell A1.

The lower box value is in cell B1.

Here’s a formula you can use:

=IF(A1<>"", "UP", IF(B1<>"", "UN", ""))

Hope this will help you.

[#3]

@NikolinoDE 

Thank you! This worked perfectly for what I needed. Totally saves me time with invoicing now and eliminating any errors. Thank you again!!!!