View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default Function question:

LOL! I thought it was a cell reference.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



wrote in message
oups.com...
AWESOME, I got it... The P1 needs to be in quotes, so the formula
would read:
=if(k2="p1",zz99)


Thanks.