IF function turning text to number

[jaquispin]

Hello,

I'm trying to do something in an Excel worksheet and I'm not entirely
sure if it's possible and if it is, am pulling my hair out as to how to
do it!

I'm basically working on a credit card cover sheet and want to show the
NET and VAT of the total amount input on a row (so I'll be doing a SUM
across five columns) whenever someone puts 'Yes' in a 'VAT receipt?'
column. When they leave blank or put 'No' I don't want the formula to
apply.

I've spent a considerable amount of time trying to figure this out and
was wondering if someone would be able to help?

I've had a go of the IF function but don't seem to have much luck when
I want the answer of the formula displayed?

TIA!

 

[Bob Phillips]

H2: =ROUND(IF(G2="Yes",SUM(B2:F2)/117.5*100,""),2)

I2: =IF(G2="Yes",SUM(B2:G2)-H2,"")

HTH

Bob

 

[Bob Phillips]

H2 should have been

=IF(G2="Yes",ROUND(SUM(B2:F2)/117.5*100,2),"")

 

[jaquispin]

Thank you very much but this doesn't seem to be helping either as i
just comes up with #VALUE?

H2: =ROUND(IF(G2="Yes",SUM(B2:F2)/117.5*100,""),2)

I2: =IF(G2="Yes",SUM(B2:G2)-H2,"")

HTH

Bob

Sorry, just seen the edited response - will give it a go now!

H2 should have been

=IF(G2="Yes",ROUND(SUM(B2:F2)/117.5*100,2),"")

Hmm, it's saying there's too few arguments? (Sorry for this!)

H2 should have been

=IF(G2="Yes",ROUND(SUM(B2:F2)/117.5*100,2),"")

------------------------------- POSTED BEFORE RECEIVING A REPLY AFTER 2
MINUTES OF ORIGINAL POST -------------------------------
Have just got it working - thank you SO much!

 

[Bob Phillips]

Have you adjusted it for your actual range?

Thank you very much but this doesn't seem to be helping either as it
just comes up with #VALUE?

H2: =ROUND(IF(G2="Yes",SUM(B2:F2)/117.5*100,""),2)

I2: =IF(G2="Yes",SUM(B2:G2)-H2,"")

HTH

Bob

Sorry, just seen the edited response - will give it a go now!

H2 should have been

=IF(G2="Yes",ROUND(SUM(B2:F2)/117.5*100,2),"")

Hmm, it's saying there's too few arguments? (Sorry for this!)

H2 should have been

=IF(G2="Yes",ROUND(SUM(B2:F2)/117.5*100,2),"")

------------------------------- POSTED BEFORE RECEIVING A REPLY AFTER 2
MINUTES OF ORIGINAL POST -------------------------------
Have just got it working - thank you SO much!

H2 should have been

=IF(G2="Yes",ROUND(SUM(B2:F2)/117.5*100,2),"")

--
jaquispin
------------------------------------------------------------------------
jaquispin's Profile: 1454
View this thread:
http://www.thecodecage.com/forumz/showthread.php?t=175945

Microsoft Office Help