#### chrissytan

##### New Member

- Joined
- Dec 9, 2010

- Messages
- 7

I can work out the cheapest Rebated price with the formula =Min(B7:AA7)

but to work out a formula to calculate the corresponding invoice price I have in the past used the formula

=IF(AB7=C7,B7,(IF(AB7=E7,D7,(IF(AB7=G7,F7,(IF(AB7=I7,H7,(IF(AB7=K7,J7,(IF(AB7=M7,L7,(IF(AB7=O7,N7,(IF(AB7=Q7,P7,(IF(AB7=S7,R7,(IF(AB7=U7,T7,(IF(AB7=W7,V7,(IF(AB7=Y7,X7,(IF(AB7=AA7,Z7,"")))))))))))))))))))))))))

in the past it has worked but with this particular spreadsheet it seems to have too many cells to calculate as when I try and put this formula in an Error comes up

"specified formula cannot be entered as it uses more levels of nesting than are allowed in current file format"

What format should I save to or how can overcome this problem.

if anyone can understand my ramblings