Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am having trouble finding the formular for column F I have typed in what i
think it should be but it keeps returning the wrong answers A B C D E F VAT 17.50% Required formula Bean £1.00 £5.88 £5.88 £5.88 =IF(C3=E3,"ok","not ok" Banana £5.00 £6.00 £7.05 £7.05 Fruit £6.00 £1.00 £1.18 £30.00 lace £56.00 £8.00 £9.40 Formular for this column =(C3*$C$1)+C3 Any help much appreciated -- Regards Nickie |