Thread: iif statements
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
cvegas cvegas is offline
external usenet poster
 
Posts: 7
Default iif statements

I am familuar with iif statements in Access but I am new to excel.

I have a cell in this workbook that references another page in the same
workbook

I want to determine if the value in that cell is =51

If it is I need to insert 126.50 into a cell and if it isn't then I need to
insert 113.00 into that cell.

I have no idea how to accomplish this. I have looked at help but do not
find anything under the iif category.

Any help would be appreciated.