Hi,
I'm trying to do a IF formula where in H1 it will automatically work out what percentage to use.
QLD 4.80% NT 4.80%
TAS 4.80% ACT 5.60%
VIC 4.80% WA 6.40%
SA 4.80% NSW 8.00%
So in H1 i want to be able to have =IF(A1="QLD","TAS","VIC","SA","NT" and D1="1st",F1*4.8%)+IF (A1="ACT", and D1="1st",F1*5.6%) and the same for WA and NSW.
Thanks.
Bookmarks