Addition to an =if formula

[TomRet]

Hello again.

Recently I had some help with this formula but I realize now that I may need to add another layer to it. Currently the formula is this:

'=IF(P3<10,"Season",LOOKUP(P3,{10,25,50,100},{"Bronze","Silver","Gold","Platinum"}))

Now, I would like to add something that leaves the cell blank if P3 is blank. is that possible? =iferror perhaps?

Thanks
Tom

[:) Sixthsense :)]

Try this...

=IF(TRIM(P3)="","",IF(P3<10,"Season",LOOKUP(P3,{10,25,50,100},{"Bronze","Silver","Gold","Platinum"})))

[TomRet]

Thanks. That keeps the 'return' cell blank when 'P3' is blank however it returns 'Season' regardless of the number placed in P3. So, where it should be 'Platinum' if p3=100 it returns season.

Regards
Tom

[:) Sixthsense :)]

It's working fine for me

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[TomRet]

I apologize. I pasted the formula into the 4th row so it was trying to pull data from the 3rd row. Fixed all that and its working fine now.

Thanks Again,
Tom

[:) Sixthsense :)]

Glad it helps you and thanks for the feedback

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.