Excel formula help

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

caniacjim

Thread Starter
Joined
Jul 3, 2006
Messages
31
I am using this formula:

IF(G1="O",FVSCHEDULE(B1,{-.0314772}),B1)

G1 does have "O"
B1 = 7.74

What I get is the number 0. I can't find any error. What am I missing?

If I just do a FVSCHEDULE(B1,{-.0314772}) it calculates properly.

I am using Excel 2000 on Windows XP Home Edition
 
Joined
Feb 20, 2006
Messages
2,255
If G1 is a number 0, then you don't put quotes around the 0 in the if function.

Quotes are normally used for text.
 

caniacjim

Thread Starter
Joined
Jul 3, 2006
Messages
31
Thanks for the response. I actually had a circular reference in a related cell. I was able to fix.
 
Joined
Feb 20, 2006
Messages
2,255
Thats fine, as long as you have got it sorted. Circular references are a pain, if you don't pick them up.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Members online

Top