Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If or
Hi,
Can someone help with the following. I have two pages in my worsheet. A formula page "OOP" and a summary Page "Summary". On the formula page 'OOP' I need: In F40 If B35 or B36 is populated add B35+B36+B37+B38+F35+F36+F37, however if these cells are empty print nothing. If B35 or B36 are empty but B37 or B38 or F35 or F36 or F37 are populated make F38 calculate =IF(B21="","",IF(B21<=0,0,LOOKUP(B21,{0,2000;30000 0,3000;600000,4500;1000000,6000}))) and add B37+B38+F35+F36+F37 + the answer of F38. (so if B35 or B36 are populated do not activeate F38, however if B35 or B36 are empty and B37 or B38 or F35 or F36 or F37 are populated active F38 and add the remaining cells to the answer of F38. On the summary page I will need to print the result in P21 but leave P21 Blank if no value is in F40 on the formula sheet. I hope this makes some sence and look forward to any help I can get. Thank you in advance. |