Using formulas within IF function??

[Aeafa]

Hiya!

I am trying to find a way to get the following info into the IF formula:

If "Sheet1!"C1=TODAY()-1 then I554 needs to be divided by 15 if not then it needs to be blank.

I am trying variations of: =IF("Sheet1!F3"=TODAY()-1, "(I554/15)", "")

But it doesn't seem to be working, and just keeps appearing blank. I'm not sure what I am doing wrong..

Can anyone please help? THANKS!

 

[Joe4]

Welcome to the Board!

It is important to understand that anything placed between double-quotes is treated as literal text. If you want to do a calculation, you do NOT want that part between double-quotes.
So try:

=IF(Sheet1!C1=TODAY()-1,I554/15,"")

 

[Aeafa]

Thank you for the welcome! I am always here reading but I have never actually needed to post before, haha.

I didn't know about the double-quotes thing! Thank you so much for clarifying that! The formula works now!!

THANK YOU SO MUCH FOR HELPING ME!! I really really appreciate it!

 

[Joe4]

You are welcome!
Glad I could help!